Ah, vb...

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim fso, f

Set fso = CreateObject("Scripting.FileSystemObject")

If fso.FileExists(DTSGlobalVariables("ImportFile").Value) then

 Set f = fso.GetFile(DTSGlobalVariables("ImportFile").Value)

 msgbox("File Size: " & f.size/1000 & " KB") 

 set f = Nothing

End If

set fso...

"First of all get rid of the Data Driven Query task".

Word...those things are utter crap.  If you follow phillcart's advice your processing will be much faster, and you will be...

I would greatly caution you against using the temp table.  Check out the two scripts below; the 1st set of statements costs 30% of the total cost.  This will scale to larger recordsets...

Just an FYI, but the seed value is just that...as seed that is used the first time only.  The increment is always applied to the last id generated, no matter...

Or you can just run this statement:

delete c1

From  company_contact c1

JOIN  company_contact c2

 on  c1.company_ID = c2.Company_ID

 and c1.contact_type_id = c2.contact_type_id

 and c1.contact_name = c2.contact_name

where c1.contact_id > c2.contact_id

thanks!  Fractals rock.

Yeah, that's what I figured...one of those hard-to-catch bugs (somebody should tell Steve or Andy, but they probably can't fix the office plugin).  can you see this?

Put your logic in a stored procedure and call that from vb.  What you are trying to do it possible, but much more difficult in VB then using tSQL.

cl

Testing....do you see the picture below?  I used the "Image Insert" option at the top.

Good job, PW; you get one "WOW" point. 

Spreading the gospel of set based processing.

cl

to create the first version of the DTS command string, use <SQL Install Root>\80\Tools\Binn\dtsrunui.exe; it's much easier to set it up that way.  Then follow the advice above, substituting the...

"Could someone elaborate on the staging method and can this be done real-time rather than batch?"

It can, but it would not be something from within SQL 2K.  As far as...

I've run into this problem before.  You'll see a similar error if you try to open up a DTS package with OLAP processing in it on a SQL Server that...

Or you can use "OPENROWSET" (see BOL).

Here's a clever solution (now that you already have one .  But this works for all cases.

Under your SQLServer install, execute the utility called...