Last post Feb 09, 2015 10:27 AM by limno
Feb 09, 2015 09:42 AM|Kanmai|LINK
I have a SSIS sql job that transfers data from SQL to AS400, each time when insert happens in the sql , i need to initiate the SSIS job to transfer the incoming data to as400. any help appreciated.
Feb 09, 2015 10:27 AM|limno|LINK
You are using SQL Server Agent to set up Job to run at schedule time. You need to set your job to run SSIS package and configure it to run at the time interval you are interested. If there is no new data inserted, the job still runs but no data flow happens