Hi Richard,

Nothing wrong with how you do it here. What I sometimes do in this kind of scenario is to create a temp table, insert all the base data and...

Richard, can you maybe give us the query that you have written so far...it will just make it easier toe either spot the mistake or help with the correct way...

It sounds like the DTS package might have been saved as a structured storage file, and not as part of the service itself. If you are trying to open this...

Hi,

I just had a quick look at this, but the problem seems to be in your join conditions. You are joining the tables on COMPANY only, and from what you've...

Hi Tony,

The problem is that you are using quotes to denote string values, and that is why you get the "" (empty string) in the text file. If you set...

Hi, you can create a job with an ActiveX scripts task and then do the following:

Dim oObj

set oObj = CreateObject("dllName.ClassName")

oObj.FunctionName()

Set oObj = Nothing

dllName is the...

One thing you must also make sure of is that you clean up your recordset objects at the end of the page, ie "Set recordset = nothing"...