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