Hey mhemp,

Interesting angle. Two questions:

1) If I create a insert trigger that calls a .bat or.exe that in turn calls up the VB app, will that have the same effect...

Hey Andy,

What is the syntax for assigning global variables using dtsrun?

I need to have the ability to kick off my application when and only when a new record is inserted. Scheduling the application to kick off at intervals is not...

Here's a different angle, can you invoke any kind of executable in a trigger

The problem is not calling the package. The problem is how do I pass the values that are being inserted into the source record into variables within the DTS package....

I haven't made any connection changes. However if someone opened the pkg from a workstation other than the orginal workstation that saved the pkg would that mess anything up?

If you are looking at speed then also look at how your DTS packages are developed. Here are some tips:

1) Develop tasks that you can accomplish using the "Execute SQL...

This is what I came up with:

DECLARE @maxcol int

DECLARE @posmark int

DECLARE @col VARCHAR(255)

declare @cname varchar(255)

declare tablecursor CURSOR for

SELECT id FROM sysobjects where type = 'U'

open tablecursor

fetch next from tablecursor into...

In DTS you can create multiple destinations and connect them to a single source using an individual transform for each destination. Just create the destinations, then hold down the ctrl...

Thanks guys, Antares in particular. Us geeks gotta stick together.

Peace out

Cool, that works on a single column. Now here's the fun part. I need to parse every column in my table to update commas with spaces. I would prefer to...

Cool, that works on a single column. Now here's the fun part. I need to parse every column in my table to update commas with spaces. I would prefer to...

Cool, that works on a single column. Now here's the fun part. I need to parse every column in my table to update commas with spaces. I would prefer to...