Configure the OLE DB Source Error Output
What is the purpose of the error output for an OLE DB Source component? How should we configure it and in what scenarios?Thanks and Regards, Franco Lopes. Ask a Question and you are fool for a second but if don't ask a question you are fool forever.
January 14th, 2011 12:12am

Suppose you have a source column ManufacturingId with values as both integer and string. You want to save all the string ManufacturingId to one destination and integer ManufacturingId to other destination. In that case you can make use of OLEDB source error output. Have a source with query as : Select 'SD121' as ManufactureId Union Select '21DS22' Union Select '213' Union Select '121' Rt click the source and select "Show Advanced Editor". Click on "Input and Output properties" and expand "OLEDB Source output" and then again expand "Output Columns". Select ManufacturingId and change its datatype from DT_STR to DT_I4. Now take the green output of source to one destination and red output to other. While configuring the error output for source make sure that you select "Redirect Row". On execution of the package you will see 2 rows each going towards each destination.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
January 14th, 2011 1:16am

What is the purpose of the error output for an OLE DB Source component? How should we configure it and in what scenarios? Purpose: Used for trouble shooting, or logging Configure: Nitesh explains that well. Scenarios: At times we need to log error for future reference as in case a particular lookup is missing. While development we can chek what kind of record is failing the task. There are various other scenarios where you could use this.
January 14th, 2011 6:10am

as Sudeep said you can use it for troubleshooting. you have 3 functions possible with the Error Output: Redirection of the rows in error or truncated rows to another task (come with the error message and the error column lineage id) Ignore the rows in error or truncated rows Fail the task when a row is in error or truncated ( default ) you saw the configuration for the redirection with the post of Nitesh. you can in an easier manner open the basic editor of a task and select the Error Output Pane to configure error behaviour row by row Ludovic Bouaziz - MCSD .net
Free Windows Admin Tool Kit Click here and download it now
January 14th, 2011 9:10am

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

Other recent topics Other recent topics