February 11, 2002 at 1:11 pm
Please help! I have been asked to write DTS Standards. I am definately a newbie (< 2 years experience) and am unsure what to include. Any advice, or recommended readings, on:
DTS Security (password protect pkgs or not\deny access to sp_add_dtspackage to prevent saving on prod servers?)
Running DTS on a app server VS running on your SQL production servers
Saving pkgs-Which method is best? SQL Server Storage?
Naming Packages?
Any other suggestions, ideas, on what to include in a DTS Standards doc would be appreciated.
February 11, 2002 at 1:16 pm
As far as where to save, Brian Knight addresses the issue in an article:
http://www.sqlservercentral.com/columnists/bknight/savingpackages.asp
Security and the like I know we've discussed in the forums. You might do a search on it. I can't recall about when, but I remember it was towards the end of 2001.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
February 12, 2002 at 10:31 am
Haven't really developed any as of yet. Be interested to see what you come up with.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy