Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dynamicly make datamarts fore bussiness Expand / Collapse
Author
Message
Posted Friday, July 05, 2013 5:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 26, 2013 6:20 AM
Points: 3, Visits: 36
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.
Post #1470678
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse