SSIS: Package has a different protection level than the project

Today I was playing around with BIML a bit and I got an interesting error message when I went to execute my package during testing. The error that popped up was:

Error    1    Project consistency check failed. The following inconsistencies were detected:     Test BIML Package.dtsx has a different ProtectionLevel than the project.         0    0    “

I checked the properties of the package I generated by clicking on the control flow, going to properties, and looking under ProtectionLevel:

image

Then I right clicked on the project level and went to properties to check the protection level of the project:

image

That checked out ok, so I thought I should check the other packages as well. I opened up another package in the project and checked the protection level:

image

Bingo. I changed the protection level to “EncryptSensitivewithUserKey”, saved it, and reran my original package. Interestingly, when I was running my package I right-clicked on it, and clicked Execute, not clicking the play debugger at the top. In 2012, since all packages are really just containers under a parent project group, the consistency check must apply to all packages in the project. I’ll have to remember that for the future.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s