How to run SQL Server Migration Assistant as a scheduled task

Question

I 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?

Answer 1

Hi jdouthit,

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.

Thanks,
Maggie

---

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.

Answer 2

Can you pls paste the errors