Importing Microsoft Access Data to SQL Server - Video Series Video Category: Data Transformation and Data Flow Tasks in SSIS: Moving Data From Point A to Point Z Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 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!

Videos in this Series:

Title Skill Length Download Part 1 - How to Import Microsoft Access Tables to SQL Server Using SSIS   200 10 mins. Download Part 2 - Limitations of the Import/Export Wizard   200 8 mins. Download Part 3 - Hand-Writing Your Own Access Import Data Flow Tasks   200 11 mins. Download Part 4 - Queries, Scripting, NOT EXISTS, and Final Thoughts   200 10 mins. Download

< Return to list of all videos