Hello,
I am trying to make a SSIS load package with I can make datamarts/Exports fore the bussines.
I want to do the setup of al the exports in 1 table like:
ID
Name
Description
Frequentie
Sourse SQL statement
Target Database
Target Scheme
Target Table
I have build a SSIS package with a Execute SQL task to get the setup variables.
That go to a For Each Container
With a Data Flow task with a source with the Source SQL statement variable.
But then i have problems to setup a destination and to dynamicly drop and create the destination table.
I am so close but can't find a solution.
Hope you could help me on how to do the rest.
If you need more information please ask.