Thanks a lot guys and much appreciation for the responses, but I figured it out this morning. I decided to test the script that i had in the execute sql task component via SSMS and it provided a much more accurate error. I had incorrect syntax for creating a trigger and it located which table had the error, but I'm not sure why SSIS sent me a connection error. Anyways its all good now

thanks guys 🙂

Lerad