Post reply

New to SSIS

  • January 10, 2012 at 10:09 am

    #262684

    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

    #1431793

    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

    #1431983

    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

    #1432588

    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

    #1434591

    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