Having recently converted a package to use the ACE drivers instead of JET to export to Excel, you need to ensure you install the 32bit version of the ACE drivers...

I believe, with result sets, only appeared from SQL 2012 onward to address the issue of using CTE's and getting similar problems to what you are experiencing. See here for...

Provided the source column was compatible your output field in the Flat File Connection Manager could be text stream[DT_TEXT]

Okay, I found the issue. It was an error in the Agent Job configuration. The SSISDB server name property was pointing to the wrong server. That's what you get for...

I inherited a similar problem with SQL 2008, however it was a unique scenario that may not apply to you. There where approximately 320 tables where data was loaded to...

In my last DBA job we designed an SSIS 2012 solution that contained 530 packages that used project deployment. All of these packages ran every night to reload tables from...

It looks like you have a bit of a mystery on you hands. As all of the tasks are contained in the For Loop setting FailParent will not help in...

Does the Error workflow attach from the OLAP Task or the For Loop? If it attaches from the For Loop  make sure Fail Parent is set in the properties of...

Swap to project deployment with different server configurations, it's so much easier.