January 10, 2012 at 10:09 am
Hi,
Designed SSIS package.
Now i need to move this package from Devlopment to Staging environment.
Can anyone share the detail process of deploying from one environment to another.
Thanks in Advance!
Regards,
Naveen. N
January 11, 2012 at 7:44 am
In the Solution Explorer, click on <package solution> -> select Properties
set Deployment utility's properties:
1. AllowConfigurationChanges=True
2. CreateDeploymentUtility=True
3.DeploymentOutputPath= <bin/deployment> //replace your own path or if you keep the same then it will create the 'bin/deployment' folder in the package location.
Now buid the package, 'manifest file' will be generated with your package name(<PackageName>.SSISDeploymentManifest) in the given 'DeplomentOutputPath'.
double click on 'Manifest file' and select the type of deployment.
if you want to deploy on 'SQL Server' than select 'SQL Server Deployment', click 'Next'.
Then select '<servername>' on which you want to deploy the SSIS package,
select 'package Path' (generally '/' is enough), check 'Rely on server storage for encryption'
click 'Next' -> 'Next'->'Next'->'Finish'
sunilreddy
http://msbimentalist.wordpress.com 🙂
January 11, 2012 at 10:48 am
Hi Sunil,
I did in the same process.
My Devlopment(SQL2K8Dev) and Staging(SQL2K8Stg) servers are having different names.
In the staging server i modified the config file connection string, parameters accordingly.
Getting following Error: The connection string format is not valid. it must consist of one or more components of the form X=Y, separated by semicolons.
Thanks in Advance!
Regards,
Naveen. N
January 12, 2012 at 8:45 am
naveen.nagareddy (1/11/2012)
Hi Sunil,I did in the same process.
My Devlopment(SQL2K8Dev) and Staging(SQL2K8Stg) servers are having different names.
In the staging server i modified the config file connection string, parameters accordingly.
Getting following Error: The connection string format is not valid. it must consist of one or more components of the form X=Y, separated by semicolons.
Thanks in Advance!
Regards,
Naveen. N
Can you post an example of what the connection string information is in the configuration file that is not working and the one that is working?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 17, 2012 at 7:04 am
Hi,
Got this resolved.
Will post with complete details.
Regards,
Naveen. N
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply