New to SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » New to SSIS

New to SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

naveen.nagareddy

Posted Tuesday, January 10, 2012 10:09 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:58 PM
Points: 30, Visits: 223

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

sunilreddy

Posted Wednesday, January 11, 2012 7:44 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 12:36 AM
Points: 12, Visits: 324

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 Smile

Post #1233987

naveen.nagareddy

Posted Wednesday, January 11, 2012 10:48 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:58 PM
Points: 30, Visits: 223

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