0

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

kucluk
  • 540
  • 2
  • 9
  • 29
  • Did you try executing it directly from Integration Services Catalogue? – umair Feb 05 '21 at 07:29
  • @UmairRamzan yes i tried execute from Catalg only 0.9 sec to success but nothing happen with the table – kucluk Feb 05 '21 at 08:05
  • Make sure your project debug runtime environment in 32 bit. You check this on project properties in SSIS. I had a similar type of issue with runtime. – umair Feb 05 '21 at 08:17
  • What does your SSIS execution say in the SSIS All Executions Report? Any warnings / messages? Furthermore it seems you are working with files (ExportToFlat, ImportToDb) - which directories are you referencing? e.g. if you read files from C:\Temp this can be processed during execution in VS but not during execution in the SSIS catalog. – Tyron78 Feb 05 '21 at 10:48

0 Answers0