DTS Error

[VBXL]

HI

I have created a Stored Procedure and it work fine in the Query Analyzer Windows but when i use a "Execute SQL Task" in a DTS, it does the stored prodedure but it does not do it all, why

Cheers

VBXL

 

[j9]

I'm not quite sure what you're trying to do, but you might double-check the workflow and package properties, etc. in the dts package to make sure that the transaction settings are appropriate. Basically, the package needs to know what to do if part of it fails. Currently, I don't execute any stored procedures in my dts, but I do execute queries as part of a transaction and don't have any trouble. Also, I do execute a s.p. as the sole step in a job. In this case, I used a transaction within the s.p. so that if part of it fails, the entire thing rolls back.