-
Stored proc hangs when DTS trigger is included
Hello:
I have a stored procedure (SQL Server 2000, SP4) that inserts data into two database tables. It is then set to run a DTS package using xp..cmdshell. The DTS package exports the database tables to .txt files and then uploads those to a DB2 database.
The stored proc without the DTS trigger works fine, and if I run the DTS trigger from Query Analyzer, it works fine also. But if I include the xp..cmdshell command in my stored proc, it hangs.
I have other stored procedures triggering DTS packages and I am not having any issues with them.
Any ideas what might be causing this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|