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?