Importing data via ODBC (from mozaic) to SQL

• Sl33py

  Mr or Mrs. 500

  Points: 532

  More actions

  April 4, 2013 at 2:09 am

  #276025

  Good Day Ladies/Gents

  I was wondering how I would go about importing data from a data source (mozaic) in the same domain into my SQL 2008 instance?

  I have set up the ODBC DNS and verified the successful connection. Now I wish to basically be able to pull data across to a SQL test DB, is this possible as I have been looking on Google and cant really find anything.

  Any help would be much appreciated.

• paulunsy

  SSC Enthusiast

  Points: 100

  More actions

  April 5, 2013 at 8:58 am

  #1603943

  Hi Sl33py

  Have you tried selecting the data across using something like:

  SELECT Field1, Field2, Etc

  FROM OPENQUERY(MYLINKEDSERVER,'SELECT * FROM MyRemoteTable')

• SteveEClarke

  SSCertifiable

  Points: 5161

  More actions

  April 8, 2013 at 6:02 am

  #1604352

  Another option might be to use SSIS and craete an update package ?!

  ________________________________________________________________________________________________
  Regards
  Steve
  SQL 2008 DBA/DBD - MCTS/MCITP

  Please don't trust me, test the solutions I give you before using them.

• Sl33py

  Mr or Mrs. 500

  Points: 532

  More actions

  April 8, 2013 at 6:08 am

  #1604354

  Thanks very much for you idea's

  I did not get far with creating a linked server, then attempting to insert the tables( we couldnt even view the data )

  so right now I am trying to go the SSIS route, and it seems to be moving slowly.