Import multiple mdb files to SQL Server using ssis package

• vishal.bhakoria-859404

  SSC Veteran

  Points: 209

  More actions

  August 10, 2010 at 2:29 am

  #146503

  How to import multiple mdb files to sql server using ssis package?????????????

  Can any one help m to do so.............?

  Please help m...........its urgent...........?

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  August 10, 2010 at 4:46 am

  #1204623

  Use a File System Task and all imports of file objects should be made on disk rather than SQL Server.

  Raunak J

• KoldCoffee

  SSCoach

  Points: 18971

  More actions

  February 15, 2011 at 9:45 am

  #1287157

  I've come to this problem myself and don't understand what is meant by 'use a File System Task'. I've used the instructions at the following link: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/710cacdd-636f-473d-af69-d28b656a9851 but find that the OLE DB Data Flow Source breaks the mdb access database to it's individual tables.

  When I am in the OLE DB source editor I am using the Data Access mode: Table or View.

  How does one import all the tables at once?