Scheduled data import from SQL Server 2005 to SQL Server 2008

• gvsriramakrishna

  SSC Veteran

  Points: 277

  More actions

  January 23, 2009 at 6:45 pm

  #72370

  Hi,

  I have a requirement to automate the import of data from SQL Server 2005 to SQL Server 2008.

  As an example:

  Daily at 12 AM I need to import data from various tables, to our local database.

  How can I automate it ?

  Please suggest

• Rajesh kasturi

  SSCarpal Tunnel

  Points: 4007

  More actions

  January 24, 2009 at 1:01 am

  #932185

  You can do it in different ways

  1. write the query to insert the data using linked server and schedule this queriy using sql server agent.

  2. SSIS package and schedule this SSIS package using SQL Server Agent.

  3. Use Import/Export wizard at the end of the wizard i think you have a option to save as DTS package.

  I suggest SSIS package because you can do more things.

  I hope this will help you.

  Rajesh Kasturi

• gvsriramakrishna

  SSC Veteran

  Points: 277

  More actions

  January 24, 2009 at 5:44 pm

  #932297

  I have tried doing it in SSIS, but saved it on the file system rather than the server object.

  I should try it tomorrow.

  Will try and post the reply.

  Thanks for the reply.