DTS log files - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

DTS log files

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-10-11 : 07:33:06

how can i get for example the last DTS run detiales like success (when wanting to reffers to a dts by its name)

thnaks
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-11 : 23:59:15

Did you run it as sql job? If not, you need enable package logging.

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-10-13 : 19:19:57

someof the time
and other time its activated with a script
why do i need to "enable package logging."
the logs are working i can see them!

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-13 : 21:31:03

You mean job history? What do you have if don't run the package as job? By the way, whatelse you need in your original post if the log works already?

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-10-14 : 02:31:43

job history i know how to pull
but if i run the DTS from a script i want to know the status of each step like how long it toke the step to finish and so on

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-14 : 16:49:49

That's why I suggest to enable package logging. But you said that the logs are working and you can see them, is it package log file? Did you get anything in that log file?

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-10-14 : 18:36:25

yes i did
and again i want to access this logs from VBSCRIPT to get there status and so on

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-14 : 20:47:39

What's package log file location?

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-10-24 : 05:15:58

i dont undersatnd your question?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-24 : 22:50:08

You have to specify log file location when enable package logging, so you can access log file in that location in your VBSCRIPT.