
January 11th, 2007, 01:38 PM
|
|
Registered User
|
|
Join Date: Jan 2007
Posts: 1
Time spent in forums: 16 m 33 sec
Reputation Power: 0
|
|
|
SSIS generate connection managers from tables
Hi,
I've got a bunch of tables I need to import data into from flat-files. The flat files are in directories, each of which contains a different subset of flat files. Each flat file is named e.g. CO.dat, which is to be imported into table PUBACC_CO. Of course, I don't want to create the many Connection Managers and so on myself. How can I first generate the Connection Managers from my tables, and then traverse my directory tree to ferret out each of the data files and import them into the appropriate tables?
Thanks,
--
Dylan Oliver
|