Hello Experts!! I am trying to call a SSIS job to process some ETL after I make an insert into
This table has CDC enabled on it, and I want to basically just trigger the SSIS job after there has been an insert into the table so the job doesn't constantly run without grabbing new data.
Basically I have one server with my database with CDC enabled on it and then my package server running my SSIS jobs.
So far I have been unsuccessful by creating a trigger and then using cmdshell to call my SQL Server job having my SSIS package.
I'm running SQL Server 2012 SP1
Do you guys have any ideas?