I found the KB article where this was mentioned, by the way:

http://support.microsoft.com/kb/308801

I am still trying to make this work. I have put the string into a .bat file...

Currently my string is this:

select @vcCmdString = 'DTSrun /E /NMAILING /G{EDE27100-CC1B-4FEB-A9E3-6E4D23E0EB5B} /V{DA7673E7-0080-406B-BC9B-DOEODA31D752} /F C:\MAILING.dts/AgvInputFile:8=" + @InputDSK + '"/AgvKey:8="' + @key + '"'

exec master..xp_cmdshell @vcCmdString

If I put spaces in...

It's very obscure, but MS does have a notation of it on their website as a known problem. I SHOULD have bookmarked the address, but I actually found it out...

I THOUGHT in my many iterations that I had tried that, but when I tried it again, it worked.

Thanks!

Kerstin

I don't know what I did, really, but it's working now. I just went back and double-checked my precedences, which I think were fine, and when I ran it again,...

I think that was Enterprise Manager's actual terminology.

I have four 'things' that the DTS package does:

1. Deletes data from two tables

2. repopulates one table using a text file (transformation)

3. repopulates...

It worked with some modification.

Since I had a complete TABLE of values for PRICE (or @d), I had to define it in a table as numeric(18,2)(sorry, my eyesight is...

I MIGHT have figured out a way to do this, but if it doesn't work, I will try to provide all of these things, and will keep this thread going.

Thanks...

Thanks! It worked, although instead of updating the ##REQUEST table I just made the first field in the table ('"' + firstcolname) as fieldone. I kept getting error messages the...

THANK you very much! That seems to have worked.