Advanced features for DTSs?

[joozh]

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

[rmiao]

Check sql books online for details.