Man, that was soooo much easier using the staging tables and SQL commands to work with the data instead of scripts. I guess I was just looking at the wrong...

Thanks for the suggestions guys! I am going to try it using staging tables today, I'll let you know hwo it goes!

Cheers,

Shawn

Code from DTS:

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

' Visual Basic ActiveX Script

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

Function Main ()

' These values were copied from the ADOVBS.INC file.

'---- CursorTypeEnum Values ----

Const adOpenForwardOnly = 0

Const adOpenKeyset = 1

Const adOpenDynamic = 2

Const...

Code from ASP page:

<%

On Error Resume Next

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

' Visual Basic ActiveX Script

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

Server.ScriptTimeout = 900

' These values were copied from the ADOVBS.INC file.

'---- CursorTypeEnum Values ----

Const adOpenForwardOnly = 0

Const adOpenKeyset...