SQL Server 2005 Integration Services DTS Package

Hot Topic

SQL Express transaction log increasing dramatically after FULL backup
Statements to recover database with encrypted data
commenting hyperlinks in query editor window
Failing to install SQL2005 Express and Standard Edition on Via Eden CPU.
terminal session name
Access to SQL server
RS 2005 Date Picker problem in Report Viewer?
Help with multiple IIFs, or need suggestion of better solution.
Numerous (every 10 minutes) Event log entries
Matrix row headers

SQL Server

Need to query max value between several colums for each row ?
Failed SQL 2005 SP1 installations (Hotifx.exe crashes)
Spaces in Column names
How connect SQL server 2000 with c#.net .....?
SCD (Slowly Changing Dim) DTS vs SSIS Best Practice
cursor problem
How to remove failed installation
sys.objects vs. sysobjects in master..sp_ stored procs
Can't start SSIS
How to reference different databases on different servers in one query

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

Answer this question

SQL Server 2005 Integration Services DTS Package

  • kshawol

    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

  • Clay E. White

    i dont know if this will work...create a job that executes ssis package. and then have the job executed from the trigger.
  • SQL Server 2005 Integration Services DTS Package
Answer this question