SSIS Can run from Visual Studio but cannot run when deployed to SQL Integration Catalog and Run Via SQL Agent

227 views Asked by At

I have issue with SQL Agent when i run it from Visual Studio SSDT its run smoothly enter image description here

No data error and rum based on flow

but when i deployed it to SQL Integration Service Catalog and run via SQL Agent the job successfully done, but no data or query executed into tables.

I already used SSDT2012, 2017 and 2019 but the issue are same

0

There are 0 answers