September 19, 2010 at 11:55 pm
Hi Everyone,
I a simple building an SSIS package that extracts information from a table and load them in another table.
I need to create a mechanism that for each error row for the source component, the row contents is converted to XML and inserted in an error table.
Can anyone please advice on how to transform the error record to XML usng
SSIS?
Thanks for your help!
Jon
September 20, 2010 at 1:07 pm
Check out this blog post, http://wiseman-wiseguy.blogspot.com/2008/08/ssis-error-logging-custom-component.html. I wrote a custom error handling component where I turn some of the error information into XML. I also reference another custom component that does XML. You can download the source for my component on the blog and see how I handle the conversion to XML. Basically you need a script component/task to do it and then do it in code.
Someone else may have a better way and if you find it, please post back here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 22, 2010 at 11:33 pm
Hi Jack,
Thanks for your help. Your link and article really helped a lot and managed to get around the problem 😉
Cheers and Thanks
Jonathan
September 23, 2010 at 4:54 am
Great. I'm glad I could be of assistance.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply