Hello,

How can I return customized error string for the scheduler/manually excuting
to write to log/double click show error?

For example

'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************

Function Main()

If something wrong
' Some statements here to "return" a customized error message.
Main = DTSTaskExecResult_Failure
exit Function
end if

Main = DTSTaskExecResult_Success
End Function

You can write to the log in an Active Script task

DTSPackageLog.WriteStringToLog "Nuts !!"

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Nick" <nbdy9 (AT) hotmail (DOT) removethis.com> wrote

I also find Err.Raise can be quite effective.


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

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

"Allan Mitchell" wrote:

Thanks.
Where to find the log? I cannot find the "Nuts !!" message in Windows Event
Log, SQL log or the log file specified for the Job step....


"Allan Mitchell" wrote:

Enable package logging.

Right Click on the design surface | Package Properties | Logging

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"nick" <nick (AT) discussions (DOT) microsoft.com> wrote