Hello all, My understanding is that there are two ways we can deploy a package to SQL server, one by running the manifest file of the project which holds the package and other option is to by "save copy of ....." option? I use the fist option when I am deploying a project initially and I use the second option when I redeploy a particular package to the server by overwriting the current deployed package after modification. While I am doing this, do I need to rebuild the project after I made the modification of the package? Since I won't run the project manifest again, does it matter if I save the copy of the package without rebuilding the project? Thanks.

You can also use the DTUtil so it will be a command line / batch based deployment. If you built the package - this is enough, but it is a good practice and does not too long to rebuild the whole project.Arthur My Blog

By "built the package", did you mean modifying it? When I modify a package, I just save it and then deploy it by "save copy of ....." to overwrite in the target sql server.

Options: 1) deployment manifest: http://msdn.microsoft.com/en-us/library/ms140117.aspx 2) dtutil Utility: http://msdn.microsoft.com/en-us/library/ms162820.aspx 3) You can even use Scripting to upload it to your SQL server: http://microsoft-ssis.blogspot.com/2010/12/uploading-all-packages-from-your-visual.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

By "built the package", did you mean modifying it? When I modify a package, I just save it and then deploy it by "save copy of ....." to overwrite in the target sql server. when you build the ssis project the deployment manifest is created in the bin folder together with the packages and xml config files (if you used any) Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Yes as I mentioned I deploy the project initially by running manifest file. I just wanted to know what ArthurZ meant by "built the package".

Yes as I mentioned I deploy the project initially by running manifest file. I just wanted to know what ArthurZ meant by "built the package". in my opinion you can't build a single package. Only the complete project... (but correct me if I'm wrong)Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com