I've tried implementing what you advised but when I try to set the error Description in a script task to an ssis variable of type string I get the following...

Could this happen even if Im using the server name?

Wouldn't that send the email regardless? Even if there weren't an error?

What Im finding is that only one task will fail but the error messages that would be all together in one job history view seperated by Error and End Error...

Ok, I went back and followed all of the instructions including enableing the DTC TCP rules for the firewall for both servers as well as my laptop and now getting...

I followed the steps in the following link and set the properties as seen on the page there. I'm still getting the "The partner transaction manager has disabled its support...

Hey guys, I followed the instructions but when I click the MSDTC tab I dont see a link for "Security Configuration". Am I doing something wrong?

I fixed it by creating a new project and adding the ssis pkgs to the new project.

Also, I'm working through a VPN from home

Permissions on folders and the file are identical to my dev enviropement as well.

Yes, I'm getting the same error. I even copied the file into another folder to make sure no one else may have had the file open but still getting the...

I have another connection mgr connecting to this excel file in a file task to rename it just before the connection manager in the dataflow is used. Could it be...

I had an error in the connection string in my table. I was trying to import from one envoroment config table to another and then run updates. Guess the...

Are you using configuration files or any other type of congiurations? Could be pointing to a different direction.

I think I known why this is happening. Ther merge join's left join will join the left input records with every record it matches on which could be more than...