Sunday, June 17, 2012 6:28 PM
I need to import multiple acccess DBs into one mssql 2008 db I have a dtsx package generated via the import tool in mssql (task import source access etc)
Sunday, June 17, 2012 7:13 PM
Please check the below link. An excellent article with examples demonstrates this feature.
Hope this helps
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Wednesday, June 20, 2012 8:28 PM
I do have one requirement after i loop through each access DB Id like to run a series of querries to append a code at the end of each record indicating what DB it originated from...any ideas