• I just did a quick search and our source safe contains an even 200 DTS packages. Fortunately I have only two databases to deploy these two.

    However, I found just recently one ex employee (not ex because of this, but it is symptomatic) has been storing his on the server. He APPEARS to have also checked them into source safe, but now we are scambling to see if the LATEST is in source safe.

    That's another reason I hate having them stored on the server, it's so easy for someone (and in a small staff all too many people have privileges that allow them to) to edit and resave a DTS package on the server and never update VSS.

    At least as a file, it's marked read only and that extra step of having to either check it out or manually mark it to overwrite reminds people!