Source Column in DTS (OnErrorEvent)
-
Hi, :) Can i get the value of current source column that failed to transform to the destination column in an OnError Event of a DTS package? I want to insert this failed value to a table for data maintenance. Thanks for the help.
I think you should post this in the SQL / ADO / ADO.NET[^] forum. This has nothing to do with C#.
Microsoft MVP, Visual C# My Articles
-
I think you should post this in the SQL / ADO / ADO.NET[^] forum. This has nothing to do with C#.
Microsoft MVP, Visual C# My Articles
Thx for your reply. Sorry for the lack of information. I'm using C# to build windows application to execute a dts package and i set an event handler for the OnError Event. So, when the error occurs i want to take the value of source field that failed to be transformed.
-
Thx for your reply. Sorry for the lack of information. I'm using C# to build windows application to execute a dts package and i set an event handler for the OnError Event. So, when the error occurs i want to take the value of source field that failed to be transformed.
There is no information passed to the
OnErrorevent handler that would give you any such information. You should look at the documentation for theOnErrorevent in the DTS Programming Reference either in the SQL Server docs or in MSDN Library[^]. My only other thought is to examine several of the string parameters to see if any additional error information is returned that you could parse, but judging by what the documentation says it seems unlikely.Microsoft MVP, Visual C# My Articles