Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Integration Services

SQL Server 2005 Integration Services DTS Package

Is it possible to create a package in Integration Services under BI to do the following in a project:

(1) Place an envent on an existing database table ,
(2) When an insert occurs to the table a Message Queue Task is executed, (3) Send stats from the table in a message to a Message Queue?

If so how do yo do this and is there a good example or tutorial that details how?

Thanks

DonH

[399 byte] By [DHardy] at [2007-12-16]
«« Pagebreaks in asp:repeater
»» Install error - Mscoree
# 1
Can triggers now be written using SQLCLR? I don't know the answer to this question but if the answer is "yes" then perhaps you could write a trigger that kicks off a SSIS package.

Just an idea.

-Jamie

JamieThomson at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
# 2
i dont know if this will work...create a job that executes ssis package. and then have the job executed from the trigger.
SureshBansal at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
SQL Server
SQL Server Integration Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified