You're going to have to deal with the protection level if you want others to use the package.

Check the technet article I referred to. You'll have to decide what level works best for your needs.

Open the package. Right click anywhere on the background (not on a task). Select 'Properties'. You'll find the protection level in the Security section.

For further information on...

To start, check the package protection level. It's probably set to 'EncryptSensitiveWithUserKey'. You'll need a different level for others to be able to execute it.

Cadavre beat me to it. I was about to post that re: the second article, note the discussion about the use of MAX vs SUM. It's a helpful...

Consider two excellent articles by Jeff Moden:

1. Suggestions about how to post data/code to get the best help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

2. Pivots and crosstab article (1 of 2 in...

Glad to hear that you got it working. Thanks for posting the end results and the UNC information.

Not sure on this one. It may be the path. I've only had success with fully qualified paths in SSIS.

That sounds correct. Have you set up tasks in the container to enumerate through?

Correct first step. I'm assuming you're accomplishing this for a SQL Task.

Under...

I usually generate multiple tab spreadsheets in a sequence container to manage the spreadsheet in one section of the package. It does not take a for/each task.

These are the...

Figured it out. I needed to change the protection level back to 'EncryptSensitiveWithUserKey' for the added package. That change unencrypted the XML. Surprisingly, it didn't ask for...

Here's another Microsoft suggestion. Don't know if you have dual monitors but, if so, perhaps this approach will help. Expand 'Detail' for the description and work-around.

http://connect.microsoft.com/SQLServer/feedback/details/357672/ssis-variables-window-is-not-displayed-properly-on-dual-monitor-setup#details

Let...

Hmm. Now you have me puzzled. A google search came up with the following from MSDN:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/94cc1c91-f699-481a-be91-703a912b0f2b/

Hopefully this approach will help. Haven't ever gotten to the...

I've run into this behavior on occasion. The approach I've found most consistent in recovering the display is to right click the general background for the package and select...