Hi,

I have a problem where they players are Sybase System 11, SQL Server
2000 and DTS.

I have a DTS package that takes data from a text file and puts it into
a Sybase table. From there I have a Sybase Stored Procedure (with no
parameters) that crunches the data (via an Execute SQL Task) and then
the DTS extracts that data into a second text file. I am connecting
to Sybase via ODBC.

When I execute the DTS package, it says that all steps have
successfully run. However, the stored procedure doesn't actually run.
The data is successfully brought into the table and then it
successfully ends up in the second text file (indicating that my
connection works fine) but none of the number crunching in the SP
happens.

When I execute the SP manually from Rapid SQL connected to Sybase, it
takes about 10 seconds to run doing inserts, updates, and deletes.
When the DTS package gets to this step, is says success in less than a
second and then goes on to the next step.

Please tell me that I can successfully execute a Sybase SP within a
SQL 2000 DTS package.


Thanks
-Brian