I have issue with SQL Agent when i run it from Visual Studio SSDT its run smoothly
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