Hello,
I posted previously about getting a SSIS package to run from a job and it was suggested I get a dedicated account to run the packages. Now I cannot even get my packages to run from the SSIS catalog. i am getting an error that my account doesn't have the correct permissions to log onto the SQl Server, which is not true as my account is a sys admin account. How do I get packages to run correctly from the catalog and from a job? Thank you.
Oops I found the error! it was a sytax error.