April 4, 2008 at 12:50 pm
I read in bol on this topic,deploying a package to sql server but i couldn't get it.I have 10 packages in one project but I need deploy only one package among them.could you plz provide me step by step process with screen shots for this process.
thanks in advance
April 4, 2008 at 4:50 pm
There may be other ways, but since the deployment manifest is an XML file you could just copy the original and edit. That would allow you to be selective about which packages from the project are deployed.
The steps would be something like:
1. BOL: Creating a Deployment Utility
2. Copy the .SSISDeploymentManifest under the \bin\Deployment\ (ex. MyDeployment.SSIS...)
3. Edit the copy, removing unwanted packages.
April 5, 2008 at 11:01 pm
Do you want to do file based deployment or sql-server?
In the first case I would copy the package directly into the destination folder, login thru SSMS and to intergration services and import the package under packages folder.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
April 6, 2008 at 9:09 pm
i want to deploy to sql server
April 6, 2008 at 10:33 pm
For sql server deployment you might have to manually edit the manifest before deploying.
You may also try installing the BIDS helper (.net addin) through which you can deploy single package.
http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Deploy%20SSIS%20Packages&referringTitle=Home
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply