I'm executing ssis package with more than 70 million data's. But I'm facing issue as
log space full error message while executing the package.
Is there any option to resolve this issue?
sql serverssis
I'm executing ssis package with more than 70 million data's. But I'm facing issue as
log space full error message while executing the package.
Is there any option to resolve this issue?
Best Answer
There may be nothing you can do except allow your log file to grow further. Without the exact message we can't be sure, but there are two reasons you might be runing out of log space:
Everything your package does will go via the log file: this is an important part of how SQL Server manges transactions in order to keep your data consistent and it can not simply be switched off or temporarily moved. You might find that your package is taking more fully logged action than it needs to in order to acheive the goal. You give no detail of the process your package follows so we can only give general guidance:
UPDATE table1 SET fiedl1=1 WHERE ID=1; UPDATE table1 SET fiedl2=2 WHERE ID=1;
is two row updates that will be logged whereUPDATE table1 SET fiedl1=1, fiedl2=2 WHERE ID=1;
is one. Over millions of rows this could stack up quite quickly. Likewise if you insert rows and later update them in the process.TRUNCATE TABLE <tablename>
instead ofDELETE <tablename>
. TRUNCATE is a minimally logged operation so will use less log space (and be much faster) then wiping the table by DELETEing every row.