Where is the SSIS Package configuration?

I created a brand new SSIS package (ETL) using Microsoft SQL Server Data Tools 2010 on top of Microsoft Visual Studio 2010.

However, the “Package Configuration” item wasn’t showing under the SSIS menu in the toolbar as I expected. After a lot of poking around and no help from the internet, I finally found it.

1.       Right click on the Control Flow white space and choose Properties

2.       Scroll thru Properties to Configurations

 

3.      Click the Ellipses (…)!

4.      Click the “Enable package configurations” and you are back in business!

I hope this saves someone else some time!

If you’re interested in learning more, reach out to us. We can help you optimize your business intelligence strategy, create a plan for managing your data, and develop user tools and data infrastructure that will drive higher levels of business performance.

Phone: 312-602-4000
Email: marketing@westmonroepartners.com
222 W. Adams
Chicago, IL 60606
Show Buttons
Share On Facebook
Share On Twitter
Share on LinkedIn
Hide Buttons