Accessing Error information in a Script Component
Hi In my Data Flow, I am sending errors to a Script Component. How can I access the error Description and Code in the following override to do row by row error handling? public override void Input0_ProcessInputRow(Input0Buffer row) Amir
May 19th, 2011 11:55am

Like Row.ErrorDescription = ComponentMetaData.GetErrorDescription(Row.ErrorCode) Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 12:00pm

Thanks Aruthur. I had already tried that, but I get a compile error on Row.ErrorCode: Error 1 'Input0Buffer' does not contain a definition for 'ErrorCode' and no extension method 'ErrorCode' accepting a first argument of type 'Input0Buffer' could be found (are you missing a using directive or an assembly reference?) C:\Documents and Settings\c0201428\Local Settings\Temp\SSIS\610ad06ef963476da4bd089b0c7e18e6\main.cs 28 64 sc_93b1672e947e42e98ccfe75819c67854 Amir
May 19th, 2011 12:08pm

You have to make sure that you also select the ErrorCode column on the Input Columns tab of the script editor (not the code editor) as a ReadOnly column. Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 12:17pm

Thanks Todd - your solution fixed it for me.Amir
May 20th, 2011 6:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics