vinu512 (10/19/2012)
So, please guys.....any other suggestions of how I could get this to work??
for the time begin you can test the SSIS package manually . see if it get blocking only by trigger call or not ? additionally i will say if you can make the ssis's stuff asynchrous then try to use service broker. SSIS call within the trigger will be cumbersome sooner or later you need to change this approach
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)