cool, i have somthing similar to that to see if they exist. I see your using a global for the foldername. Is this bit of code only used for one...

Great, thanks for the insight!

I do have a question about DTS if anyone knows. How can I loop through a recordset in DTS? What I need to do is select...

Yes, other apps do update this table. What I need to do sounds very simple.

1. Grab a set of records from table1 that don't match table2. (the inconsistancies)

2. Update table2...

Thanks, That will work great for the updating. Here's the last part- I also need to write to a log table for every update. How can I insert a row...

ok, stamp a big "LOSER" on my head. The data type for the variable was different than my column data type!

thanks for the help anyway

Thanks for the fast reply.

I do have a global variable from another sql task object. I know it works because I use it in a active x script. When...

Clive, you rock!! thanks, I'll give it a try!

Can I update multiple databases with 1 dts package? Do you know of any sites that might help guide me through making a package of this type (I new to...