MS SQL Server 2005 Bulk Copy question

VCInDSX · Post by **VCInDSX** » Tue Jul 29, 2008 7:39 am

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,

josh.guffey · Post by **josh.guffey** » Tue Jul 29, 2008 7:45 am

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...

VCInDSX · Post by **VCInDSX** » Tue Jul 29, 2008 7:53 am

Hi Josh,
Thanks for the followup. Appreciate it much.

Correct me if i am wrong, my understanding is that the "SQL Server Enterprise" is not available on Linux/Unix Server installations.
Or is there a way to "bring in" this stage on a Linux/Unix installation?

Thanks again

chulett · Post by **chulett** » Tue Jul 29, 2008 8:00 am

VCInDSX wrote:Correct me if i am wrong, my understanding is that the "SQL Server Enterprise" is not available on Linux/Unix Server installations.

Your understanding is correct, Windows servers only.

VCInDSX · Post by **VCInDSX** » Tue Jul 29, 2008 1:47 pm

Thanks Craig.