SQL Server Performance Forum – Threads Archive

A DTS Package to archive data from one sql server

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.

if you working on sql server 2000, you have posted this post in worng place [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] you can you export/ impotr wizard of the SQL Server 2000 and select sql serer and objects that u wnat to trnafer. PN: If u don’t have objects in tharget database it wont create indexes . relations and triggers. —————————————- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com</a> Visit my Blog at http://dineshasanka.spaces.live.com/</a>

This is a learner question and for that I suggest to go through the books online andhttp://www.sqldts.com website to get on with it.
http://technet.microsoft.com/en-us/library/aa933485(SQL.80).aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Also…
http://vyaskn.tripod.com/sql_archive_data.htm
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>