Hello

I Have a simple Qeustion

I want to get in an ActiveX Script the last error message
because I'm starting this script when the last Task falls. In this script I
send a mail to me what was the failed step, but I can't read the really
reason and I ever have to look into the DTS Pakage what was really wrong

could you help me please?

greetings from Germany/north Bavarian

Rainer

You may be able to use/adapt this script

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/Default.aspx?208,2)

the GetExecutionErrorInfo method of the Step object.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Rainer" <rr (AT) asdf (DOT) de> wrote

Hallo

this script is very fine

but I don't start the package from VB
I want to read the error from an ActiveX Script insite the DTS package

greetings

Rainer

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:eXzILAW8DHA.2760 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

good point

GetExecutionErrorInfo uses ByRef arguments and these have to be strongly
typed so VBScript blows up.

You might try wrapping this in an COM wrapper and using that instead.

Not pretty I grant you.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Rainer" <rr (AT) asdf (DOT) de> wrote