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

How to check the Deployment utility of a Package Expand / Collapse
Author
Message
Posted Tuesday, December 22, 2009 3:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:46 AM
Points: 114, Visits: 404
Hi All,

I am planning to create a re-usable asset for my team "to check the Deployment Utilities created for the package".

Some times my team members forget to check "Enable Package Configurations" in "Package Configurations Organizer" under "SSIS -> Pacakge Configurations.." menu. This leads to many confusions when SQE deploy with their test server names and package tries to connect to dev servers (which were used during package development).

SO, I want to have some utility using which my team members can check the deployment utility created to know whether "Package Configuration" option is enabled to ensure that package would connect to the server which are given during deployment time.

Any thoughts on how to create utility for this? Or any existing tool which I can leverage on?

Thanks.
Suresh



Regards,
Suresh Arumugam
Post #837816
Posted Wednesday, December 23, 2009 6:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:27 PM
Points: 1,117, Visits: 2,219
Suresh Kumar-284278 (12/22/2009)
Hi All,

I am planning to create a re-usable asset for my team "to check the Deployment Utilities created for the package".

Some times my team members forget to check "Enable Package Configurations" in "Package Configurations Organizer" under "SSIS -> Pacakge Configurations.." menu. This leads to many confusions when SQE deploy with their test server names and package tries to connect to dev servers (which were used during package development).

SO, I want to have some utility using which my team members can check the deployment utility created to know whether "Package Configuration" option is enabled to ensure that package would connect to the server which are given during deployment time.

Any thoughts on how to create utility for this? Or any existing tool which I can leverage on?

Thanks.
Suresh



Suresh,

I think you will find this post useful.


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #838477
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse