Can a DTS Job restore access from a remote client

• mngong

  SSCertifiable

  Points: 6167

  More actions

  July 15, 2005 at 8:30 am

  #114356

  Is it possible to  convert an access db from a remote server to a sql server database on another server  with DTS.

  Any help will be greatly appreciated

  Mike

• July 18, 2005 at 8:00 am

  This was removed by the editor as SPAM

• urvashi

  SSC Enthusiast

  Points: 115

  More actions

  July 19, 2005 at 5:41 am

  #575438

  Hi,

  not very clear with the question

  . do you want to migrate the access database to a sql server database.

  If yes then you can copy all the data in access database tables to a database in sql server through dts.

  Regards

  Urvashi

• ann ramos

  Right there with Babe

  Points: 791

  More actions

  July 19, 2005 at 5:35 pm

  #575677

  here's what i did.

  in dts i created an access connection that points to a file in another server.

  then i created an sql connection that points to another server.

  connect the 2 objects with a transform data task and specify the mappings.

  a table was created in the remote server that contains the records from the access.

  so, from your local server you can transfer stuff from one server to another.

  hth.

  ann