How to reuse a set of components on Data Flow taks of SSIS
Hi I am a newbie in SSIS. I wrote a sample package in which I configured a Data Flow Task something like shown below
Output from a OLE DB Source
|(error output)
(Script Task )
开发者_运维知识库 |
(Sort Task )
|
(OLE DB Destination)
From another path in the same Data Flow task can I add the output to Script task something like shown below
Output from a OLE DB Source Output from a another OLE DB Source
|(erroro/p) |(error o/p)
| \\\\\ ///|
(Script Task )
|
(Sort Task )
|
(OLE DB Destination)
My intention here is to reuse the mapping made for handling errors in the Same Data Flow Task.
Any sugesstions?
If you are trying to combine error output from different sources, you can use Union All
transformation within Data Flow task
to combine the output which can then be passed onto other transformations or destinations. Please refer the below screenshot in which the data flow task has two flat file sources. The successful rows are combined using the Union All transformation Success rows and then passed onto the Success transformations and destination. Similarly, the error output rows are combined using the Union All transformation Error rows and then passed onto the Error transformations and destination.
Note:
Here both the flat file sources use the same file layout.
Hope that helps.
精彩评论