InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 00:54:03 GMT20http://www.sqlservercentral.com/Forums/Topic837816-148-1.aspx[quote][b]Suresh Kumar-284278 (12/22/2009)[/b][hr]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[/quote]Suresh,I think you will find this [b][url=http://sqlblog.com/blogs/jamie_thomson/archive/2009/11/07/ssis-package-stats-collector-version-2.aspx]post[/url][/b] useful.Wed, 23 Dec 2009 06:23:50 GMTCozyRochttp://www.sqlservercentral.com/Forums/Topic837816-148-1.aspxHi 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.SureshTue, 22 Dec 2009 03:18:40 GMTSuresh Arumugam