I am creating a DTS package after specifying the source, destination and tables, save, schedule, And package package , which has a Save DTS package checkbox.
Does anyone use this option to save my DTS package? What is the meaning, and what can its professionals and the opposition do? (Especially if you have experience with different options, and are not just regurgitating.)
This
The file is portable and standalone it can be run with dtsrun.exe And do not require full installs to run on the App server.
The MSDB option means that you need access to the MSDB database but you can recover backup / restore capability.
It depends on your setup and shop. I like the file option, but I'll use it as needed.
I will not use these:
Some more information on this has not been updated. SSIS has mostly changed DTS.
No comments:
Post a Comment