Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
dtsconfig with the Project Deployment Model

Unanswered dtsconfig with the Project Deployment Model

  • Sunday, March 03, 2013 7:52 PM
     
     
    Sign In to Vote
    0

    Hi,

    We're switching over to 2012, and I'm keen to get the logging and reporting benefits of the Project Deployment Model. However, I'd rather not go through the pain of changing all our packages from configurations to parameters at this stage.

    I know it's possible to convert packages to the Project Deployment Model, and still have the configuration screen in design model that we're used to seeing in 2008. However, it seems that once they're deployed to the SSISDB, all notion of external configurations goes out the window. I've tried to call the packages on the server from dtexec, which I can do, but the packages retain the variable settings and connection settings that they were saved with i.e. they don't pull in configurations from the external source at runtime.

    I've also tried to use the /CONFIGFILE flag with dtexec at runtime, to specify another config file to use, and this just gets ignored.

    Can someone please confirm that this is the behaviour of 2012, and that I'll need to switch to parameters if I wish to use the Project Deployment Model.

    Thanks,

    Adam

     

All Replies

  • Monday, March 04, 2013 10:23 AM
    Moderator
     
     
    Sign In to Vote
    0

    Haven't used them in the 2012 Project Deployment Model, but the old configurations are still available. Not in the menu, but in the properties of the package:

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

     
  • Monday, March 04, 2013 10:30 AM
     
     
    Sign In to Vote
    0

    Hi,

    Yep, I've saved my packages like this, and have then done the conversion to the Project Deployment Model.

    So far so good.

    But when I run them on the server, the configurations are ignored.

    Adam

     
  • Monday, March 04, 2013 10:38 AM
    Moderator
     
     
    Sign In to Vote
    0
    Are they still available (and enabled) in the package properties in SSDT after conversion to 2012 project deployment model?

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

     
  • Monday, March 04, 2013 11:41 AM
     
     
    Sign In to Vote
    0

    Yes, they are.