Access 2003 MDB to SQL 2005

I need to move the tables and queries in an Access 2003 mdb file into a sql 2005 database.  Will SSIS do this?  If so, how?
Thanks.
LVL 5
sinjinAsked:
Who is Participating?
 
Om PrakashCommented:
Please check the following link for migrating views and stored procedures:

http://technet.microsoft.com/en-us/library/cc917601.aspx
0
 
Om PrakashCommented:
0
 
sinjinAuthor Commented:
Thank you...
That speaks to moving tables.  What about views and stored procedures?  Will that work too?
0
 
sinjinAuthor Commented:
Are you trying to tell me the is NO WAY to accomplish this except cut and paste?  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.