Hi,
We have jobs that read from sequential files and load into target MS SQL Server 2005 tables using ODBC Enterprise as per the following design.
SeqFile ==> Transformer ==> ODBC Enterprise
Is there any Bulk Copy/Load stage for MS SQL Server 2005 that one could use for such operations?
Thanks,
MS SQL Server 2005 Bulk Copy question
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 40
- Joined: Thu Apr 17, 2008 1:52 pm
- Location: Huntsville, AL
Replace the ODBC Enterprise with the SQL Server Enterprise Stage. That is the target stage that we use to load our SQL Server databases and it seems to perform much faster than ODBC.
I would create a copy of the job and change the copy's target to SQL Server Enterprise. Run job 1 and then the copy and see if there is any difference in load times, etc...
I would create a copy of the job and change the copy's target to SQL Server Enterprise. Run job 1 and then the copy and see if there is any difference in load times, etc...