How to deploy ssis Packages to production Environment
Hi All, I have a few questions regarding ssis package deployment to production environment. In order to deploy already developed packages ...These are the things I am following...Please confirm whether I am following the correct approach...or not.. If not please let me know the exact process.. First of all I am generating the scripts for databases...corresponding tables,views and stored procedures.. Once the scripts are ready... I am executing those scripts in production environment. After that I am adding all of my developed packages to production environment BIDS Platform. Then I am running these packages in production environment (All connection strings are updated in the configuration file)...by changing the Configuration file.. Then I am scheduling all of these packages through SQL SERVER JOB AGENT..... Is this the right approach ...? Please let me know ASAP... vineesh1701
November 29th, 2010 3:31am

Hi All, I have a few questions regarding ssis package deployment to production environment. In order to deploy already developed packages ...These are the things I am following...Please confirm whether I am following the correct approach...or not.. If not please let me know the exact process.. First of all I am generating the scripts for databases...corresponding tables,views and stored procedures.. Once the scripts are ready... I am executing those scripts in production environment. After that I am adding all of my developed packages to production environment BIDS Platform. Then I am running these packages in production environment (All connection strings are updated in the configuration file)...by changing the Configuration file.. Then I am scheduling all of these packages through SQL SERVER JOB AGENT..... Is this the right approach ...? Please let me know ASAP... vineesh1701 HI Vineesh all seems fine but why are adding ur already developed package to bids .. u can generate manifest file and install ur developed packages at prod machine directly y in prod machine why un necessarily open bids and open any window for errors [by mistake ] .. just generate manifest from ur final tested project deploy ur packages in production ... change configuration files/ sql configuratione etc .. with respect to ur project in production ... and run the job ... check out on generating manifest : http://www.sqlservercentral.com/blogs/dknight/archive/2009/06/30/ssis-creating-a-deployment-manifest.aspx you can as well create job in ur development machine .. script it out and then change server etc . values run the job creation script in production .. and u r good to go with production environment .. Hope that helps ... Kunal
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 3:37am

you can simply create package deployment utility, http://msdn.microsoft.com/en-us/library/ms137952.aspxhttp://www.rad.pasfu.com
November 29th, 2010 3:41am

detailed information: http://www.bidn.com/blogs/DevinKnight/ssis/82/ssis-creating-a-deployment-manifesthttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 3:45am

Hi All, Thank you for the Quick Response....Do we need IntegrationServices to be installed on the Production Environment for Deployment of SSIS Packages...?vineesh1701
November 29th, 2010 5:52am

you can use DTUTIL or other deployment tools to deploy your package from development environment to production remotely. BUT you need SSIS for running package on production environment and you can not avoid it.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 6:10am

Do we need IntegrationServices to be installed on the Production Environment for Deployment of SSIS Packages...? vineesh1701 yes !!! you do but u already mentioned that u are using bids in prod environment ...... Hope that helps ... Kunal
November 29th, 2010 6:17am

Yeah..BIDS is already there...in Prod Env...Its my question...can we deploy packages in prod..without installing Integration Services..? Anyway..Thankyou allvineesh1701
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 6:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics