Search Suggest

REFLECTION
REFLECTION

Redirect duplicate rows

Case I have duplicate records in my source which I want to redirect to a separate destination in my data flow task. Most solutions like the Aggregate…

Flexible XML Destination

Case A client wants to export data to XML files, but SSIS has no XML destination. A script component could help him but he doesn't want to create…

Do 'something' for all columns in your dataflow

Case If you have a lot columns that all need to be adjusted with the same function (let's say uppercase). You could use the Derived Column compon…