March 27, 2007 at 8:14 am
Hi, in SQL2000 you can go into a DTS package, right click, select package properties then enter a filename in the 'logging' box so that you can capture the success or not of the DTS package each time it runs to a txt file. Can someone please let me know how to set this up in 2005. I've migrated a package from 2000 to 2005 which had an error log configured but it doesnt use it.....thanks v much
March 28, 2007 at 10:04 am
It's not quite so simple in SSIS. Open the SSIS package, right click in white space, choose Logging. There you can choose where you want your logs to go (text file, table, xml file, etc.) and you can choose the level of the package at which you want to log (easiest to just choose top level) and which events you want to log, such as OnError, OnWarning, OnPipelineRowsSent, PackageEnd, etc. Make sure after you ADD your destination for the logs, that you check the checkbox in front of it.
Check books online for more details.
I agree, the text files were nice and easy in 2000, not to mention the package logs on the server.
March 22, 2011 at 9:29 am
-- SQL Server 2005
select * from [YOURDB]..sysdtslog90
-- SQL Server 2008
select * from [YOURDB]..sysssislog
may be this Web Site will Help u =
=======================
March 23, 2011 at 4:18 am
r_win_kurn (3/22/2011)
-- SQL Server 2005select * from [YOURDB]..sysdtslog90
-- SQL Server 2008
select * from [YOURDB]..sysssislog
may be this Web Site will Help u =
=======================
Since this thread was started in 2007, I guess the OP has already solved his problem or he doesn't care about it anymore 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply