query to get the Packages logging information

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

General SQL Server Forums

New to SQL Server Programming

query to get the Packages logging information

Author

Topic

newuser001
Starting Member

19 Posts

Posted - 2009-04-29 : 13:20:48

I am righting a query to get the Packages logging information from for all the servers in the enterprise that are enabled for logging are not.
I found that if the logging is set to error file (text file) i can’t find the information in the systables
and if the logging (log package execution) is set to different server i cant find the logging details on that server systables where the packages are.

My query goes to all the server systables and gets the information
Can any pls help me………how to find these 2 details too.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-29 : 13:24:10

can you check inside package the path & name of file to which error is logged?

newuser001
Starting Member

19 Posts

Posted - 2009-04-29 : 13:30:23

hey vikash thanks..

yep i can see the path of the file and the file too..

my query is not able to get these details because its not in the systable (sysdtspackage,sysdtspackagelogs....etc)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-29 : 13:43:45

if you can get file name, cant you look into file to get logging info?

newuser001
Starting Member

19 Posts

Posted - 2009-04-29 : 13:58:49

I am actually trying to create a Report which gives the Logging details of all the DTSPackages logging is enabled or not in my environment (i want to make sure all the packages has logging enabled)

I am getting wrong details in my report because
for few server the packages logging is route to differnent server or to errorfile

ex: In server1 there is a DTSPackage ABC but the logging information of this server is route to differnet server2
i am not able to find theses package details in the server1 systable.
where my query goes to all the server one by one and gets information from systable i am not able to find the detalis of the package ABC
In my report its shows the the logging is not enabed for this package ABC (where the log package execution is routed to server2)

Similarly even when the logging is set to error file(text file) i am not i am not able to find the correct detalis of the package ASDF
because those details are not saved in the systable(sysdtspackage,sysdtspackagelogs....etc)
In my report its shows the the logging is not enabed for this package ASDF (where the logging is routed to error file)

Did u get me ? sorry i could not explain u clearly..let me know

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources