Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-29 : 11:25:38
|
| immiH writes "SQLTeamI have a DTS package that, for an initial load is pulling back just over 25 Million records. Unfortunately the LOG file gets filled up.Because this is an initial load, and one into the staging area of a data warehouse I am not really interested in logging the transactions, is there a way of telling a package not to log transactions?(I'm using the Transform Data Task to load from one SQL Server db to the staging db)I know that it would probably have been easier and neater to use bcp, but my predecessor decided to use this method, hence I'm stuck with it!Your assistance is greatly appreciated" |
|
|
|
|
|
DTS package fills Transaction Log