SSIS can be fussy sometimes.

I'd load the package up in visual studio and try to recompile it with the data source pointing to the same one as your...

If you are just wanting to run the SP manually via SSMS and save the results to file, press ctrl+shift+f and then run the SP.

C# would be pretty...

To me, I still say your memory is over utilized for that server.  That was what my first post about it was and I stand by that claim still.
You...

No problem.
The other option would have been to use "OR" and have 2 entries in your where clause.

As a thought, do either of these VMWare KB's help:
https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1009517
https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2008925

This would only apply to the VM's, not the physical machines.
The power profile settings...

Where I work, we are working on removing linked servers where possible.
We are replacing them with  a combination of Service broker and SSIS.
We have our data warehouse which...

Based on your description (I didn't look at your excel files), what you are asking for is not possible.

You state that TransTable_Description is a column which is no problem....

If I understand the problem correctly, you have filestream access turned on pointing to M: but you removed the M drive.
Did you re-point the filestream access to I:?  Are...

You should just be able to take the DTSX's and import them into a new project in VS2012.
The issues you will likely have are more related to the SQL...

Jacob, thanks for pointing out that those are blank not null as with my solution.

Update to my solution, replace the first INSERT INTO [#code2] section with:
[code...