Hello Tim,

Russell has good advice. You also asked about returning an error. To where?

I have never tried to execute a package from within a stored procedure, but
when I execute a package from a SQL Agent job using DTSRUN, the job will
report failure when there is a failure within DTS. So, perhaps on the next
line following your DTSRUN, you could check @@ERROR for success/failure.
Likewise you could throw an exception up the call chain back to your ASP page.


In addition, you can capture your DTS execution in a log file. In the
designer window, right-click on an empty space & choose "package properties".
In the logging tab, you can log to either SQL server or to an error file.
For simplicity, I log to Error File by providing a path to a text file.

Fair Warning: Logging appends data to the file for each run, so you'll need
some outside process to empty it from time to time.

Let us know how you make out.

Regards, Tom

Thomas Bradshaw
Data Integration Services
MyWebGrocer

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200901/1

Thanks for the ideas.

I will give them a try this week and let you know how it turns out.

I am running an asp page calling the stored proc. I was hoping there
was a way to have the asp page receive the error if it happened. I may
have to capture the log file and display it or a portion somehow on
the page.

Thanks,

Tim

On Jan 27, 12:00*pm, "tbradshaw via SQLMonster.com" <u12692@uwe>
wrote: