In this essential video series, Scott Whigham will walk you through the process of migrating your Access data to SQL server via use of Integration Services, and via hand-writing your own script! Scott, in this video series, will also cover more about custom queries and scripts you can generate for importing Access data, and also some of the pitfalls and limitations of the Import and Export Wizard for migrating data from Access to SQL Server in SSIS.
Highlights from this series:

• *When not to use SSIS for importing Access tables
• Working with the Import and Export Wizard
• Creating a column primary key
• Import/Export Wizard downfalls
• Alternative option to using Import/Export wizard
• Using IF NOT EXISTS

and much more!