April 20, 2008 at 11:54 pm
Hi All ,
I am currently working on a custom error Logging dll , which will capture the errors that would occur in a ssis package at runtime and log the error details into a custom table in the database . The details that are required are error description , package start time and end time , task in which the error occurred , type (i.e warning or error). I am almost done with dll , but I have no idea on how to add the dll to the package . I dont want to call the execute task to add the dll . Is there any other way in which`I could do it ?? Can you please provide me some help on how to do it ??
- Kannan
June 24, 2008 at 7:03 pm
It really depends on how your dll is receiving these values. If you are planning to use the system variables then your dll has to be called by a custom task or script task.
But if you want to make Custom Log Provider then be aware that Log Providers does not have access to the variable values, but the log is called when the Package Starts and Ends and any event that you check for the logging. So you can get the information you want by creating a Custom Log Provider.
Check the MSDN link below for sample of how to create Custom Log Provider.
May 15, 2009 at 2:28 am
thanks for your reply..
the link was useful...
May 2, 2011 at 11:21 am
See this very good article about ssis package logging
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply