Didn't know that - personally never used the SSIS store for packages, always deployed mine by using DTEXEC. Good to know. Can you update them the same way?

You could probably identify which packages are doing the work by using some form of audit mechanism. Like, for example, if it's an UPDATE on a table, you could put...

There is no "average" memory capacity on SQL Servers 😛

I've worked with some that have as little as 2GB of memory, and some that have as much as 16GB. I've...

I generally use SSIS only when the tasks either involve files which are outside of the database, IE flat files, excel files, etc ... or when the sheer amount of...

Also remember if you're not pipelining your data flows properly, and you have blocking parts like Aggregate or SQL Command objects, then you are going to be loading way more...

What you can do is use a Script Task. Within the Script Task, use the DirectoryInfo.GetFiles("*.log") command to create an enumerator with all the files in the directory. Then, use...

That sort of operation is kinda ugly in SSIS, because ideally SSIS is supposed to be used as an ETL operation - in other words, take a set of data,...

You have two alternative, albeit somewhat ugly, options.

If the EXECUTE SQL TASK is performing a SELECT statement against a table, then perhaps what you could do is re-name that table...

I wonder if in SSIS 2008 or Denali, they were smart enough to change the default setting on an SSIS package from EncryptSensitiveWithUserKey to EncryptSensitiveWithPassword. The ease of having no...

What's your question peterzeke? This thread is very old, with several different questions and answers within.

Welsh's solution should work, assuming you read through it all.

Long story short, change the ProtectionLevel on your package from EncryptSensitiveWithUserKey, to EncryptSensitiveWithPassword, or EncryptAllWithPassword. Create a password. When you deploy...

Did you try re-creating the excel connector and destination and see if it still fails?

you're really not providing enough details here on what your problem is.

You say you tested it before deploying on live server. You mean you took your package, and had the...

Pretty open-ended question. If you're asking whether you can deploy an excel file destination to a remote server, then sure, you can, just use the full UNC path when specifying...

I was thinking Derived Column Transformation, but there's no built-in split function, so you'd have to have one very, very long script to go through all the different components. Something...