Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Advanced features for DTSs?

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2006-04-17 : 04:09:40
Hi,

Since I am new to DTSs therefore currently I am making my DTSs in a manner where there probably is a room for improvement e.g. When I have to Import data from one server to another I use the Import feature and then I go through all the steps of the wizard (at the end of which I get the option to save my DTS)....

In the DTS "design window" there are many options under the TASK menu option and is there a url from where I can learn how to use these options (under TASK i.e. File Transfer Protocaol task, ActiveX Script Task, Transform Data Task, etc. etc.).

Maybe if I know how to use these options, I might be able to write my DTS in better and flexible manner...

Hope my posts is making some sense????

Thanks

Thanks & Regards.

-J

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-04-17 : 04:12:33
You can look up Books Online on DTS and also http://www.sqldts.com/



KH


Go to Top of Page

Joozh
Posting Yak Master

145 Posts

Posted - 2006-04-17 : 04:27:39
Will do so. I hope the url will provide the desired info.

Thanks khtan :)

Thanks & Regards.

-J
Go to Top of Page
   

- Advertisement -