Just digging thru the articles and have to say I am ROTFLSHICB (Rolling on the floor laughing so hard i can't breath just in case you don't know). I previously...

Ok I am still not fully sure I understand what is happening. Can you post the details of the PtCh table and give me and example of what is happening...

DTS wrappers are COM based so will work fine. Just found this take a look will help http://www.asp101.com/articles/carvin/dts/default.asp

"Don't roll your eyes at me. I will tape them in place." (Teacher...

No such critter (sorry in a mood). You can however create a global temp table (##tblname) to stored data and pass between. It will remain in affect for the duration...

From BOL

quote:

---

The Eager Spool logical operator will consume the entire input, storing each row in a hidden temporary object stored in...

Without going to much into it it should work just like writing a VB app to execute a DTS package. See the various examples of that, you will have just...

Actually directly there is nothing. But try this

DECLARE @beginval AS int

SELECT @beginval = @@IO_BUSY

WAITFOR DELAY '00:00:05'

SELECT @@IO_BUSY - @beginval FROM sysprocsses

Since @@IO_BUSY represents the amount of input and output operations...

I would think you could do the file method and create a package on server B to pull the file without him having to know what to do. However you...

If you are running SQL 6.x then take a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q225490

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Also for this situation make sure you have the database recovery model set to Simple.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Thinking about this did you happen to create this package on a SQL 7 server with a 2000 client. If so what SP are you running of SQL 7? If...

A few thoughts here.

1) Have you stepped thru the VB to get the exact string it is passing? Could be the string contains a where criteria that it shouldn't that...

Ok a few questions.

1) Do you have multiple file groups and had planned not putting them in Primary?

2) Is Primary filegroup set with a maximum size of growth? Are you...

If this will be automated using SQLAgent on another domain may give issues with permissions of the account SQLAgent is using(sorry I haven't tried but a trust between the domains...

Try this

exec sp_msforeachdb 'sp_grant_revoke ''revoke'', ''developers'', ''P'''

It may not like your use of " (double quotes) but when you use ' (single quotes) you have to double singles around text...