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 ««12

Dynamically load CSV files To Sql Server Tables Expand / Collapse
Author
Message
Posted Monday, February 4, 2013 2:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 16, 2013 11:20 AM
Points: 45, Visits: 139
Hi Phill
i have understand what u said,.

should this link is good for dynamic mapping ?
http://wikiprogrammer.wordpress.com/2011/04/08/dynamic-column-mapping-in-ssis-part-1/

and if i used static connections instead of dynamic ones, then how will i tell For Each Loop to enable particular connection manager for loading data in sql server
?
Post #1415492
Posted Tuesday, February 5, 2013 1:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 16, 2013 11:20 AM
Points: 45, Visits: 139
HI phill
Thanks for explaining the main point. Now i understood.

I have a question. if i go for a static source of five excel connection as source and five ole db connection as destination
and they are in for each LOOP.
Then how could i make one source to make active and other four to be non active based on iteration of for each loop.


Thanks
Post #1415634
Posted Tuesday, February 5, 2013 2:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 16, 2013 11:20 AM
Points: 45, Visits: 139
HI phill

First of all thanks for making me clear about dynamic source.

i have a qs: if i have a data flow task inside for loop container. and DFT contains five static connections of FLAt file as Source and Olde db as Destination .

and i want that on every iteration of For Loop . one out of four connection work.

how could i achieve that?

thanks
Post #1416100
Posted Wednesday, April 24, 2013 12:27 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:05 PM
Points: 355, Visits: 870
My version of this is: "If column definitions in either the source or the destination are different, for any of the files, it will not work"


If the above is not your case then try a FOR EACH loop container to gather the files in your directory that you need to import. This implies they all be in one place/folder.
Post #1446177
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse