Sunday, 15 June 2014

visual studio 2012 - SSIS Project Deployment server name and project path missing on .ispac double-click -



visual studio 2012 - SSIS Project Deployment server name and project path missing on .ispac double-click -

recently had problems production deployment of our ssis project through .ispac team performing installation deployed wrong project folder , messed our production environment :)

our environment: sql server 2012, visual studio 2012 ultimate, ssdt 2012

the installation process double-click on .ispac through deployment wizard. problem on "select destination" page, "server name" , "path" fields aren't automatically filled , had browse project folder in ssisdb , got wrong (there project similar name). wizard recognize server , path configured in configuration settings of ssdt project, far haven't got luck.

we have 5 different environments, each different values "server name" , "server project path" on project property page (configuration properties > deployment > deployment model (project)). in theory plenty wizard recognize settings right?

also, if deploy project development server straight vs2012 destination fields correctly filled, can't utilize method production deployment unfortunately.

is there way forcefulness ssis deployment wizard recognize deployment settings when double-clicking .ispac?

visual-studio-2012 ssis sql-server-2012 ssdt

No comments:

Post a Comment