Last post Feb 10, 2015 02:25 PM by limno
Feb 10, 2015 11:05 AM|Kanmai|LINK
Could someone please help me with the code to trigger an SSIS package when data is inserted in a table on server 1(SQL) ?
The SSIS package would then copy the data to another table on server 2(Db2).
or any other work around help is appreciated.
Whenever new record is inserted in SQL immediately i need to get that on DB2 server.
Feb 10, 2015 11:52 AM|JoyceW|LINK
This link will show you how to execute a package from a stored procedure. If you already how to write a trigger, this will give you everything else you need:
Feb 10, 2015 02:25 PM|limno|LINK
Use a scheduled job to run your package instead of using a trigger may be a better option.
You may run into other issue to work with trigger to transfer data.