DSXchange

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,

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

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

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.

Thanks Craig.