Not bad Steve - have you considered just putting the VBScript into a job rather than as a DTS task?

Andy

I'll try to get some sample code up tomorrow or Friday, got a lot going on this week. In the interim if you search MSDN for ado stream you should...

You will also have to use named pipes for the connection to the 2nd or later instance if you're not running the latest MDAC (I think 2.6 or higher).

Nigel -...

Hey now...since I haven't passed the 6.5 exam Im not a pro?!!

Joe, I'd say go for the SQL 7 exam since that is what you're using. As far as training...

Thanks.

Andy

ASP will work. Biggest thing is your code gets all wrapped up in your UI. Depending on the scope of your project you may want to wrap DMO in an...

In fact you may not need to convert it - SQL does a fair job of figuring out that the value is a date. Run this code to see what...

Thanks for the code Erik!

Andy

I think the biggest difference is that you can't (I think, Im a VB guy, not ASP) is that you cant handle the events. For instance, if you want to...

You're trying to mix two techniques. The easiest way is to use two ado recordsets, so you're just assigning the contents of one column to another, like this:

rsDestination.fields("ImageField")=rsSource.fields("ImageField")

Getchunk works, but...

Here are a couple links from MSDN that may prove helpful:

http://support.microsoft.com/support/kb/articles/Q199/7/08.ASP

http://support.microsoft.com/support/kb/articles/Q131/5/34.asp

I found what looks to be a pretty good article about upsizing to SQL from Access that I think also...

How about trying the same task through Enterprise Manager? You can always drop the db if it works.

Andy

Makes you appreciate the work EM does behind the scenes on items like this doesnt it?

Andy

Well stated. The problem is that not only are we unlikely to convince them, it's not always realistic anyways. Gotta pay the bills first. I've tried to adopt the dual...

How about this instead?

select * from main_table a

inner join (select rec_id, min(drop_date) as DropDate from drops where drop_date is not null group by rec_id) b

on a.record_id=b.rec_id

Andy