deployment options

Hello all,

I am considering the different options for package deployment on the server.

Until now, I have found several different ways to deploy packages to the server (File System):

1. Using the Import option from the Management Studio (only one by one)

2. Using the Deployment Utility (Needs building the whole project. Opens all the packages in debugging mode, cannot deploy to different folders)

3. Using the dtutil by constructing a command line for each package deployment. (complicated)

4. Simply copying the files from the local project folder to the "Program Files\Microsoft SQL Server\90\DTS\Packages" folder on the server.

Does anyone have any other suggestions for deployment?

The 4^th seems to be the easiest one, but I seen anybody suggesting such an action. What's the downside of such an action?

Thanks,

Liran

The 4th option IS easiest but you do have the potential for human error. You could easily write a batch file to do the same thing however and just amend that as necassary.

-Jamie