Home Forums Data Warehousing Integration Services Importing one file into two database tables RE: Importing one file into two database tables
Ant-Green
SSC Guru
Points: 113445
More actions
January 9, 2013 at 8:46 am
#1575298
Within the same DFT, just drag in another flat file source and another destination and mapp the two.
So 2 Flat File Sources, pointing to the same Flat File Connection Manager, 1 OLE DB Destination to DB1, 1 OLE DB Destination to DB2.