November 18, 2010 at 8:16 am
Hi,
I have been trying to work out how to do this.
I am wanting to implement custom error handling in one of our SSIS packages and I know I can capture errorcode, errordescription, taskname and insert those into a table.
I have created a user variable called TableName and I would want to use that too.
What I would like to happen is in the event handler of my data flow task, for it to capture the tablename the source is pulling from and insert that tablename into my custom table.
There are around 50+ tables in the one data flow by the way.
Is this possible? If you have any documentation or can point me to any tutorials on the net for doing this, I cannot find anything useful. I am quite a newbie to SSIS.
Thanks for reading
Jayne
November 18, 2010 at 11:31 am
Well, for a newbie you're already doing pretty OK 🙂
But regarding your question, I don't think it is possible.
But what are you exactly trying to log? Every source/destination table in your dataflow or only the ones that have an error?
Maybe you can programmatically access your package and find all the tablenames there. (but if that's possible, it will be tricky to implement).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 18, 2010 at 11:44 am
Have you taken a look at this article: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62662/
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply