HELP: DTS showing successful completeion, when not

[amylewisAZ]

Hello,

Created a DTS package that connects to a Sybase database and excutes a stored proc on the Sybase side to bring data over to SQL Server.

The DTS Package says it successfully completed, even though it really didn't.

Ran Profiler trace, but it didn't show anything. Seems that the DTS package isn't reading the status correctly from Sybase. The stored proc on runs fine on the Sybase side, but doesn't seem to run correctly whan ran from the SQL Server DTS package.

Any pointers on how to troubleshoot this?

Thanks,
Amy

 

[john76]

I'm not sure if this is the problem that you are having or not, but it is something you can at least explore (and something that I have seen rather often around here).

When SQL Server executes a package, it considers the package successfully executed even if one or more tasks/steps fail UNLESS you enable the "Fail package on first error" option (Package Properties -> "Logging" tab -> checkbox at the bottom.) or set one or more of the steps "FailPackageOnError" property (using disconnected edit) to true (1).

Hope this helps,
John