Sunday, March 11, 2012

Advanced features for DTSs?

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??

ThanksThere are good online tutorials to learn basic dts.I think u should go through that.This site is good for dts.
http://www.sqldts.com/

No comments:

Post a Comment