September 10, 2008 at 8:35 am
Hi,
If an error has occurred at OLE DB Destination, I'll have to concatenate all the columns coming from the source into a single string and I'll have to insert that string along with the current time into the error table (for the purpose of logging).
This can be achieved using derived column. But the problem is, the number of input columns can go upto 30 or 40. So, I wanted to automize the process (possibly using a script component). I've tried the function "Row.toString" in script component, but it is giving me a wierd string ("ScriptComponent_da3a33911e9244979a254aa38801c681.InputBuffer").
Please suggest a solution to concatenate all the input columns into one string.
Thanks in advance for your help,
Manohar.
September 10, 2008 at 8:55 am
I wrote an article on error handling in ssis that has code for this except I am creating XML. If you serch for error handling in ssis you should find the article. Also you can check out my blog using the blog link as I have created a custom component to create the XML content. The source and component are available from a link on my blog.
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 11, 2008 at 2:39 am
Thanks a lot. It was of great help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply