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.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-10-14 : 10:55:25
|
| hi guys i asked before and still i have not a solution for that.i used ssis 2005 but and i want to see log each package in my solution.i know the logging in sssis but it is not nice to read it.what do you use? ( i like what we have in sql 2000 in the DTS- i can see information in each step in the dts,so if i have error i can see it on the step) |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-14 : 11:11:38
|
| I use the SSIS logging to text file. It shows errors for every step, if selected.I've also logged to a table. But prefer the text files. I find it easy to find the errors.Usually I redirect the output to a log file, in addition to the timestamped log files.That is: DTEXEC /f "S:\Package1.dtsx" > Package1.logThis way I always check the same filename, and it's less cluttered.Sorry, I can't remember DTS logging in SQL 2000 anymore. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-10-14 : 13:43:56
|
| suppose you have 50 package so , you have 50 log files?you check just error in the logging?(in sql 2000 you have Package Log on the DTS ,how do you use without log on the DTS?) |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-14 : 16:11:39
|
| We use Log Parser to scan for errors in any logs. It's a fantastic little utility.And rely on a scheduling tool to alert when a job/package fails.Having separate log files, allows for easy archival, clean-up, debugging - I think. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-10-15 : 02:32:04
|
| i dont know if it is the best wat but thanks. |
|
|
|
gaauspawcscwcj
Starting Member
29 Posts |
Posted - 2009-10-21 : 03:44:14
|
| like a farmer use script task to write log if your task going falsegaauspawcscwcj |
|
|
|
admin@binaryworld.net
Starting Member
2 Posts |
Posted - 2011-05-02 : 13:15:59
|
| See this very good article about implementing [url]http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx[/url] |
|
|
|
|
|
|
ssis logging