You can loop through the steps of the DTS and execute a stored proc that logs the information into a "Log table".

I use the following code to accomplish a similar...

Do you know what the differences are in performance for using the temp table method vs. using a derived table in the stored proc?

I'm using SQL Server 7. Is there any other way to do this than using a temp table and without modifying my original stored proc 1 to use a...

I'm not sure. I was not responsible for the install/configuration of SQL Server. How do I find out?

Thanks to all for your responses.

The information provided has been very helpful.

Thanks!!!

But if you build the input parameters into the SQL string in the variables, then can't you get the same result?

Say for example, you have a stored proc with...

create procedure...

Are you saying that you can do something as simple as the following...

declare @x nvarchar(4000)

declare @y nvarchar(4000)

declare @z nvarchar(4000)

set @x = 'Place first 4000 characters'

set @y = 'second 4000...

I agree with Shas3 -- sqldts.com is an excellent site. You might also want to look at the following article...

http://www.asp101.com/articles/carvin/dts/default.asp

Also, SQLServerCentral.com (this site) is the best resource....

Thanks for the replies!!!

I agree with Michael -- for small arrays, the split function would work fine, but I'm dealing with a large array, so I guess I'll just save...

Oh -- I did not know that tidbit of info about the 10 stars. Well, that certainly helps in the debug process.

I believe it is connecting properly, because I...

The following SQL definitely results in an INNER JOIN...

SELECT A.*

FROM TABLE_1 A LEFT OUTER JOIN TABLE_2 B

ON (A.KEY = B.KEY AND B.FLD_1 = 'criteria')

It is the same thing as using...

I'm guessing that the NOT IN logic would work the same way?

Forgot to add that I'm using SQL Server 7 if that makes a difference --

probably not in the case of VBScript.

Would something like the following statement work in this case…

SELECT fields, SUM(fields)

FROM

(SELECT fields FROM table_1 WHERE condition

UNION ALL

SELECT fields FROM table_2 WHERE condition)

GROUP BY fields

So there's no other way to get at this information???