Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Anand.A
Posting Yak Master
109 Posts |
 Posted - 2011-12-12 : 00:17:23
|
| hii want to know what s different between deployment utility and deploy the package in ssisanand |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-12 : 00:40:37
|
| deployment utility is an wizard driven deployment tool. deploy a package means more generic it can be done manually or via deployment utility. In former case, you manually connect to Integration services engine of your server,expand stored package node MSDB or filesystem and manually browse to package and export it.This is ok for single package but while deploying a whole project consisting of several packages it can be quite cumbersome.In latter case, you just need to include all packages in a project, build it and then launch the deployment utility. The wizard will guide you and do the deployment of whole packages in project together. It saves a lot of effort in getting packages deployed to your server. You even have facility to alter values of configuration items while doing deployment through utility.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-12-12 : 01:43:38
|
| ya very thanks for ur reply..now by using deployment utility i deployed my project..i am having more than one package in my project..so if i want to run my whole project how to do that in that bin folder..anand |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-12 : 10:16:18
|
quote:
Originally posted by Anand.A
ya very thanks for ur reply..now by using deployment utility i deployed my project..i am having more than one package in my project..so if i want to run my whole project how to do that in that bin folder..anand
just need to include all the packages under same integration services project, build the solution after setting create deployment utility property to true under project properties.Then it will create deployment manifest file under bin folder after copying all package. Double click on manifest to launch deployment utility and set required values inside the wizard to deploy the packages to required server under required folders (MSDB/file system)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
deployment utility