trowsell (11/14/2012)
Thanks all...I've just done a count and the actual number of rows transferring will be about 3.5 - 4 million rows a day and about 4Gb.
Why do you expect using SSIS will avoid database log file growing?
I was thinking along the lines of when you do an export (ie right click on the DB, go to tasks, exports) that it doesn't fill the log files, so when transformed to an SSIS package it wouldn't either.... or is that a wrong assumption?
Exports (reading data) doesn't log. Importing (writing data) does, doesn't matter how it's written, it has to be logged.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability