Package deployment
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.
May 19th, 2011 1:48pm

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
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 2:04pm

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.
May 19th, 2011 2:24pm

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
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 2:32pm

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
May 19th, 2011 2:37pm

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".
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 2:39pm

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
May 19th, 2011 2:49pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics