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 |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2009-03-27 : 10:30:38
|
| I have a C# console application that runs a number of SSIS packages. If one fails, I'd like to be able to print the error message to the console. Currently, I only know of a way in C# to write the result (success or failed). Is there any way to do this? Do I have to create an event handler for each package? I hope not! |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-03-27 : 12:33:04
|
| Write the error log to file and read the file in C#. |
 |
|
|
im1dermike
Posting Yak Master
222 Posts |
Posted - 2009-03-27 : 13:55:02
|
| How do you write the error log? |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-03-27 : 14:51:30
|
| Menu: SSIS > LoggingYou can write it out to text file or xml. In your C# app you can put a FileWatcher to notify you when there's a change to the log file.Also, Google "ssis error logging" and you'll tons of examples. |
|
|
|
im1dermike
Posting Yak Master
222 Posts |
Posted - 2009-03-27 : 15:23:57
|
| Interesting. Thanks a lot. |
|
|
|
|
|
|
Writing SSIS package error to console