how can I use the sql 2008 import feature to import multiple access 97 dbs
-
Sunday, June 17, 2012 6:28 PM
hi
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)
All Replies
-
Sunday, June 17, 2012 7:13 PM
Hi robMerritt
Please check the below link. An excellent article with examples demonstrates this feature.
Hope this helps
Irshad
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
BH
- Proposed As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, June 18, 2012 8:49 AM
- Marked As Answer by robMerritt Monday, November 12, 2012 3:46 AM
-
Wednesday, June 20, 2012 8:28 PM
thanks Irshad
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
.png)
