Hi DTS gurus,

I have two question :

1) How can I pass INI value to DTS Global Variable ?
Can I use Dynamic Properties Task ?

2) I use Exedute SQL Task to exec SP, but how can I get the Error message if
error happen in SP execution ?

Thank you for your help,
Trist

1 - You can use the Dynamic Properties Taks to do this.

2 - Use the DTS logs, you cannot capture it reliably inside DTS. Check you
have patched your machines as well. See this KB for a fix included in the
latest security patch

FIX: A DTS Package That Uses Global Variables Ignores Error Message Raised
by RAISERROR
(http://support.microsoft.com/default...b;en-us;815115)



--
Darren Green
http://www.sqldts.com

"tristant" <krislioe (AT) cbn (DOT) net.id> wrote

"tristant" <krislioe (AT) cbn (DOT) net.id> wrote:
Heh, I'm no guru...

Absolutely!

That's how I do it. I think that might be the only way TO do it,
since
I believe that's the only way to get to an INI file without doing some
ugly kludge.

That one I'm not entirely sure about... If nothing else, I THINK you
can
rewrite the proc to use an output parameter rather than "return"-ing
the error code, and in the Task, use a "?" for a parameter, which you
could then send where you needed it to go.