2012年3月5日 20:01I am having to import data from Access 97 into a SQL Server 2008 R2 instance. The import works using SSMA. However, I can't link the tables or create an SSIS import package to continue importing data. Both fail. I would like to somehow run the import using SSMA on a regular automated basis. Is this possible? If so, how?
I do not think you could run the import using SSMA on a regular automated basis. You could create an SSIS import package and run it as a job.
If you have problem in creating SSIS import package and importing data, you could get help in this forum: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/threads?page=2.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- 已标记为答案 Maggie LuoModerator 2012年3月14日 15:04
2012年3月7日 16:02Can you pls paste the errors