Thank you for the reply, that is what we are currently doing. I have setup a package that calls all the stored procs that do the dynamic SQL. I was...

You should be able to open SQL Data tools on from the 2012 box and open the project and upgrade all packages. When we did this we wanted to keep...

Thanks for the response, it actually was a security issue we were actually testing a new service account on that box which did not have rights. We switched it back...

Sorry I meant to say "from what I can tell windows authentication is what is needed to run the new ssis stored procedures."

Listed below is a part of the stored procedure I am trying to execute that will fail just running this will not work. I can execute anything to this server...

No currently just trying via SSMS. We will end up with a .net application calling it, but not until we can get this working.

On the HTML format I use those for other notifications. The report that is built contains a ton of data, runs a lot of custom procs and is client facing...

Hello Matt,

Thanks for getting back to me this worked perfect for what I was trying to do.

The cache connection transform should build from scratch every run.

Resolved the metadatavalidation set to "FALSE" did work but I had to close the package and re-open for some reason.