SSIS Creating Destination Table Dynamically From Source Table
Posted on 2012-04-10
When creating a Dataflow task within SSIS, the source is created and then a OLE DB Destination is added, there's an option to Create a table dynamically when you press the NEW button inside the OLE DB Destination Editor.
I'd like to build an SSIS package Programatically and I would like to create the destination table dynamically, just as if I press the New button within the code. Would anyone know how to do this?
Your insight is appreciated.