Importing CSV file into MS Access Database using Integration Services

• jman76

  Hall of Fame

  Points: 3388

  More actions

  July 26, 2011 at 6:21 am

  #254344

  I need to automate the transfer of a CSV file into a MS Access database on a daily basis. Is it possible to automate this using SQL Server Integration Services. If so does anyone know how I can do this..ieSteps?

  Many Thanks

• Chuck Hottle

  SSCarpal Tunnel

  Points: 4777

  More actions

  July 26, 2011 at 11:00 am

  #1358675

  Probably by executing DTExec.

  http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx