creating a package to export data from access database to sql server 2008 database

• raj.prabhu001

  Right there with Babe

  Points: 758

  More actions

  November 25, 2013 at 6:58 am

  #300864

  HI,

  i want to create a package to export data from Microsoft access database(2007) to sql server 2008 database .

  there is one table access database i want to export only that table to sqlserver.

  So please provide me the Steps to do so, im a beginner in SSIS.

  Thanks.

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  November 25, 2013 at 7:34 am

  #1668797

  Hi,

  Please read this link:

  http://technet.microsoft.com/en-us/library/cc280478(v=sql.100).aspx

  It's clearly explained there.

  Br.

  Mike

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 25, 2013 at 7:41 am

  #1668800

  michal.lisinski (11/25/2013)

  ---

  Hi,

  Please read this link:

  http://technet.microsoft.com/pl-pl/library/cc280478(v=sql.100).aspx

  It's clearly explained there.

  Br.

  Mike

  And for people who like the explanation in English instead of Polish 😉

  How to: Connect to an Access Database

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  November 25, 2013 at 7:47 am

  #1668803

  Forgive me for my previous link, I've alerady changed for us-en.