Thread: DTS Package Creation

Hi
Am new in creating the DTS Package.I need to create a DTS Package in SQL server where i need to archive some of the data from few tables. Like i need to get more than >10000 records and have to move those data from the original DB to another DB.Guide me in creating the Package.

Thanks in advance

Cheers,
Siva
--No one is Born Genius--

How do you expect us to help you without knowing what exactly is the problem at your side.

I have created a DTS Package in sql2005 using Business Intelligence studio and i have the package in my desktop. I need to schedule the package(atleast for one time execution) and execute it. How it can be done.

Thanks,
Siva
--No one is born Genius--