Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTSRUN - Capturing Errors

Author  Topic  szgldt Starting Member 10 Posts Posted - 2006-01-13 : 08:35:21 I have written a DTS package that checks for a spreadsheet and imports the data into a SQL Server table. It then moves the spreadsheet to an archive directory. I have created a stored procedure to run the DTS package using the DTSRUN command as I need to invoke it from a VB app. Is it possible to capture, from within the SP, if the DTS Package has failed to complete (i.e. one of the steps failed) using the DTSRUN command? Thanks, Andy