SQL Server Performance

A DTS Package to archive data from one sql server

Discussion in 'Getting Started' started by madhavi, Jun 7, 2007.

  1. madhavi New Member

    Hello...

    I am very new to SQL server.

    I have no idea as how to create a DTS package in SQL server.
    Now I need to create a DTS package to archive database and some tables in one database from one server to another.

    Could anyone please explain the steps to create the DTS Package to archive a database from one server to another.

    Any of your help will be greatly appreciated.

    Thank you in advance.
  2. dineshasanka Moderator

    if you working on sql server 2000, you have posted this post in worng place [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />you can you export/ impotr wizard of the SQL Server 2000 and select sql serer and objects that u wnat to trnafer. <br /><br />PN: If u don't have objects in tharget database it wont create indexes . relations and triggers.<br /><br />----------------------------------------<br />Contributing Editor, Writer & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><br />Visit my Blog at<br /<a target="_blank" href=http://dineshasanka.spaces.live.com/>http://dineshasanka.spaces.live.com/</a><br />
  3. satya Moderator

  4. MohammedU New Member

Share This Page