Grant,

Thanks again for your reply. What I'm really trying to do is to capture the Row Count in a user variable using the Row Count transformation (seems easy enough) and...

Grant,

Thanks for your reply. I am following the SQLIS examples exactly and still the same results. My query will not parse or work with the ? as a parameter. I...

Lowell,

thanks for your quick reply. That looks like it will work. My only concern is performance. If I am inserting 1,000,000 rows, the trigger has to be executed 1,000,000 times....

Thanks for your reply Eddie. I wound up doing it in a job step using T-SQL script which calls extended procedure xp_cmdshell. Its seems to work pretty good.

declare @rt...