Hi All,

How can we handle / know the errors occured with in the DTS Package?

Also Can we Return/Retrieve any Value (say the final value of a Gloabl
Variable after the package is executed) to the Caller Program, Like a Stored
procedure?

Any Suggestion or Web Site for reference.

Thanks in Advance
Prabhat

There are two logging options, to a SQL server or to a file for packages as
a whole.
Any executing program should really also check the results and expose this
correctly.
I would also suggest you code defensively, and check potential error
conditions before they are hit.

If using the OLE stored procedures to call the package from T-SQL then it is
possible to read global variables out after execution.
You could also write any values you want to and external location from
within the package.

Darren Green
www.sqldts.com

"Prabhat" <not_a_mail (AT) hotmail (DOT) com> wrote

Hi Darren,

Thanks for your reply. If I am using OLE Stored Procedure then and also Set
the Global Varibales in the package before I execute.

But can u give me an example to Retrive the Value of a Gloabl Var after the
Package is execute successfully?

Thanks
Prabhat

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote