Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Haaksbergen, Netherlands
    Posts
    69

    Unanswered: How to put data from a recordset into a table

    I want to transfer a recordset (derived from an Oracle datasource) into
    an SQL2000 Server table using VBScript in a ActiveX Script Task using a DTS.

    Currently I use the OPENROWSET (and OPENQUERY) method, however
    the lenght of the querytext seems to be limited to 8192 bytes.
    At this moment I have reached the limit of this lenght, and I am looking
    for a solution.

    Futher info: The query returns large recordsets of 100,000s of records with 100s of columns. Because of it's complex structure, the standard data transformation in SLQ2000 is not an option.

    Using a substitute like:

    varRecords = rst1.GetRows
    For intI = 0 To UBound(varRecords, 2)
    rst2.AddNew
    For intJ = 0 To UBound(varRecords, 1)
    rst2(intJ) = varRecords(intJ, intI)
    Next
    Next
    rst2.Update

    works fine but is much to slow.

    Can anyone help me to find a solution?

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    It may be a better option to use BCP. I'd actually post this msg in the MSSQL forum.
    That which does not kill me postpones the inevitable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •