I have a set of DTS packages I have built to transfer data
from MSSQL 7.0 tables to a Sybase 12.0 tables. Some are
quite large and the inserts could take 45 minutes. BCP is
much faster - I have a copy statement that transfers the
data to the Sybase server, but to execute the Sybase bat
file to trigger the bcp in has not been happening. The
DTS package states it is successful, but there is no data
being inserted. I've tried it within DTS, as a job, as a
stored procedure - all say successful - but no results.
Any ideas?