Jan 312012
 

I’m going to blog this in case anyone else has run into the same issue.  I recently tried to create SSIS Package Configurations using SQL Server Data Tools (SSDT) in a SQL Server 2012 environment in Cloudshare.

As always, I right clicked on the Control Flow designer for my package expecting to see the Package Configurations option on the menu.  The option was not there.

image

So I searched msdn I found the instructions for 2012 tell me to select Package Configurations from the SSIS menu.  http://msdn.microsoft.com/en-us/library/ms141132(v=sql.110).aspx  I did that, but it’s not there either.

image

I haven’t been able to find a solution to getting this option back into my menu, but I did find a workaround.  In my Package Properties window there is an option for Configurations. 

image

When I click on the ellipsis I get the Package Configurations Organizer window I am looking for.

image

Just click on the Enable package configurations checkbox and away you go as normal. 

I will be posting a blog shortly on some best practices for defining and reusing Package Configurations across your solution using a Package Template.

As an aside, I did also come across this interesting blog post on Parameters in Denali.  As he states, they don’t replace Package Configurations, but it is another way to go.

http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/11/parameters-in-ssis-in-denali.aspx

  30 Responses to “SSIS 2012 – Package Configurations Menu Option Missing”

  1. In SSIS 2012, package configurations are available for the legacy package deployment model. The BOL topic referenced above (http://msdn.microsoft.com/en-us/library/ms141132(SQL.110).aspx) is targeting this scenario. The topic has been updated to make this clearer. The updated topic will appear in the next Web refresh of 2012 BOL.

    When a project is configured to use the project deployment model, by design the Package Configurations command does not appear on the SSIS menu.

  2. Thanks for this blogpost. I think this may be the only entry online about this issue as of today. I don’t think the BOL also has been updated and I do not see any details about getting the option back in the SSIS Menu. Lastly is there any good discussion online about the merits of password protecting the packages compared to using the package configuration option. Thanks

    • If you check out Carla’s comment, she explains that in SSIS 2012 package configurations are available for the legacy package deployment model. When a project is configured to use the project deployment model, by design the Package Configurations command does not appear on the SSIS menu. It seems that package configurations are being phased out in favour of using package variables.

      Regarding the merits of using password protection, I only use package configurations when environments might change regularly. I don’t do it for security reasons. If you set the security on your package to Encrypt sensitive with user key, others can’t see your passwords when opening the packages in BIDS/SSDT or when triggering the packages. Check this out for more info – http://msdn.microsoft.com/en-us/library/ms141747.aspx

      Cheers,
      Martina

  3. Exactly what I was looking for. Thanks…

  4. Thanks…

  5. Thanks for that. Just what I needed!!!

  6. Thanks!

  7. This is what i was looking for,Thanks .

  8. Thanks a lot…

  9. Thanks for this and guess what, after first time, I can see the Package Configuration link by right clicking just as before. So only first time appears to be the problem.

  10. Thanks for ur info I have been waiting for that option for a long time

  11. Thank you.

  12. BOL still has the non-working information so thanks very much for this. Spent an hour looking for it and only found it after finding your article.

  13. Thanks. I was looking for this!

  14. Thanks a lot…

  15. Thank you Martina White !

    That is what I looking for.

    Satish

  16. straight to the point and extremely helpful ! thank you

  17. Thanks it helped

  18. Thanks you kept me
    right direction

  19. Thank you.

  20. Thanks this was helpful

  21. Thank you so much..so small a tip saves a lot development time

  22. Thank you

  23. […] bis ich die Einstellung für package configuration in Visual Studio 2012 gefunden habe … Hier ist der Link zur […]

  24. Thank you

  25. Thanks a lot! It helped me a lot!

  26. Thank you!

Leave a Reply to Kent Rothrock Cancel reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

Wordpress SEO Plugin by SEOPressor