What's the easiest way to log task steps inside DTS? I need to create and
examine some of the variables at certain points as the package steps through
the logs. I need to do it as a Job - verses running it interactively.

--
___________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

Hey Joe, (Sorry, I could not resist the Hendrix tribute!
As for development purposes, I use the good old MSGBOX, but it might not suit you
For production pursoses, I write each watchpoint in a LOG_STATUS table with a Connection Object or a SQLTASK
HTH


----- Joe wrote: ----

What's the easiest way to log task steps inside DTS? I need to create an
examine some of the variables at certain points as the package steps throug
the logs. I need to do it as a Job - verses running it interactively

-
__________________________
Joe Horto
Database Developer / Software Enginee
WISHA/Legal Services Software Developmen
Department of Labor and Industrie
Voice (360) 902-5928 fax (360) 902-620

Yes - MSGBox works well for Dev - I'm struggling with a scheduled Job - can
you send me a code snippet of how you use the Log_Status -thanks!

"Valmir Meneses" <anonymous (AT) discussions (DOT) microsoft.com> wrote

In message <4532F710-2D4F-40B2-B70F-CCFDD9911D0D (AT) microsoft (DOT) com>, Valmir
Meneses <anonymous (AT) discussions (DOT) microsoft.com> writes

In addition-

You can write to the DTS Task log, which comes out in both the package
log file and the tables used by the log to SQL Server option for a
package-

DTSPackageLog.WriteStringToLog "My String"

DTSPackageLog.WriteTaskRecord 1, "Desc"

See the PackageLog object in Books Online for documentation of this
object.

--
Darren Green

Hmm - doesn't like:

Function Main()
DTSPackageLog.WriteStringToLog "test"
Main = DTSStepScriptResult_ExecuteTask
End Function


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

In message <1022e8phfetl63c (AT) corp (DOT) supernews.com>, Joe
<hortoristic (AT) yahoo (DOT) com> writes
Help me out a bit, what is the error?


Perhaps I should mention that this is for SQL Server 2000 only. People
rarely post the version these days, so I just guess, and use the answer
which sounds best

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Yup SQL2k

Error is:
Error Code: 0
Error Source=Microsoft VBScript runtime error
Error Desc: Object required: ' DTSPackageLog'

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

In message <1022g9l4mtcle1e (AT) corp (DOT) supernews.com>, Joe
<hortoristic (AT) yahoo (DOT) com> writes
Is this in an ActiveX Script Task? For some (annoying) reason the log
object is only available in the Task, not workflow or transform scripts.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thanks - I got it working - it was really weird - appeared to fix itself
once I exitted package or something. I got it working as a standalone
ActvieX.

What a pain it doesn't work in workflow.

Thanks for your notes Darren.

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

When using WriteTaskRecord instead of WriteStringToLog - where in the DB
does it write that?

Also - once again it doesn't like my syntax:
DTSPackageLog.WriteTaskRecord (DTSGlobalVariables("gLocalServer").Value)

"Joe" <hortoristic (AT) yahoo (DOT) com> wrote