Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

New to SSIS Expand / Collapse
Author
Message
Posted Tuesday, January 10, 2012 10:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, June 1, 2013 1:49 AM
Points: 30, Visits: 224
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
Post #1233382
Posted Wednesday, January 11, 2012 7:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 31, 2014 12:44 AM
Points: 19, Visits: 378
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
Post #1233987
Posted Wednesday, January 11, 2012 10:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, June 1, 2013 1:49 AM
Points: 30, Visits: 224
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
Post #1234203
Posted Thursday, January 12, 2012 8:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1234905
Posted Tuesday, January 17, 2012 7:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, June 1, 2013 1:49 AM
Points: 30, Visits: 224
Hi,

Got this resolved.

Will post with complete details.


Regards,
Naveen. N
Post #1237203
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse