BCP Load Stage for Sybase/MSSQL Server
Posted: Wed Jul 20, 2005 1:53 am
Has anyone ever gotten the "Sybase BCP Load" stage to work with MSSQL Server 2000 ?
It appears that it worked with MSSQL 6.0 but hasn't for future releases of MSSQL Server as the changes to the core has made it quite different to Sybase. Is this really true ?
So instead of BCP'ing data straight into a MSSQL Server table I now have to write my data to a file, ftp the file to a directory on the SQL Server where a detection process takes the file and "bulk inserts" it onto the target table. (ODBC - too slow and not an option).
I'm hoping that I'm missing something simple here and it is just a blip on my part. On the other hand if it is no longer possible then shouldn't DataStage support for a previous function be maintained even if the supported vendor in question changes their core.
Pity the poor customer who had bcp working between DataStage and MSSQL Server 6.0 who had to upgrade their MSSQL Server and suddenly found their processes unable to run - this surely can't be true especially as MSSQL 7/2000 have been around for at least 6 years.
It appears that it worked with MSSQL 6.0 but hasn't for future releases of MSSQL Server as the changes to the core has made it quite different to Sybase. Is this really true ?
So instead of BCP'ing data straight into a MSSQL Server table I now have to write my data to a file, ftp the file to a directory on the SQL Server where a detection process takes the file and "bulk inserts" it onto the target table. (ODBC - too slow and not an option).
I'm hoping that I'm missing something simple here and it is just a blip on my part. On the other hand if it is no longer possible then shouldn't DataStage support for a previous function be maintained even if the supported vendor in question changes their core.
Pity the poor customer who had bcp working between DataStage and MSSQL Server 6.0 who had to upgrade their MSSQL Server and suddenly found their processes unable to run - this surely can't be true especially as MSSQL 7/2000 have been around for at least 6 years.