Hi, I am new to ssis packages.My requirement is something like this. I am having 4 different databases called Brazildb, Germanydb, Austriadb, Francedb .All These dbs having same table ‘country_tbl’. Now I have 4 different country csv files called brazildata.csv,Germanydata.csv,Austriadata.csv and Francedata.csv I have to migrate the data like below: Brazildata.csv to Brazildb.dbo.country_tbl Germanydata.csv to Germanydb.dbo. country_tbl Austriadata.csv to Austriadb.dbo.country_tbl Francedata.csv to Francedb.dbo.country_tbl Pls note that the structure of table ‘country_tbl’ in all the 4 dbs is same. Also the colums defined in the csv files also same. But the country wise data in all the csv file is different. Can anyone guide me how to create a single package instead of creating 4 different packages for importing the data, as I am having all similar table in dbs and different csv files. Is it possible to create a single package where we can change the connection string for each db and csv file path?Please anyone can give me steps for creating the packages? (Actually I need to migrate 500 csv files to a similar table in all 500 dbs.I cannot create 500 packages in short time.So I am looking for solution where I can create a single package with multiple db connections and import from different csv files in their respective country db table.or please give me any alternate solution?) Thanks, Pols pols

take 4 dataflows in the controlflow. In each dataflow select the individual source and destination. I think it will work...!

I can not place 500 dataflows in one single package.:( any other alternate?pols

I cannot place 500 dataflows in one single control flow. :( Any other solution?pols

Pols http://beyondrelational.com/blogs/sudeep/archive/2010/03/14/dynamically-set-flat-file-connection-manager.aspx http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspxBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/