Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Unanswered: DTS: EXCEL TO SQL: Returns an empty recodset

    Hi there,

    I use Asp.Net Application to upload a Excel file and then a DTS to import data from the file to the SQL2000 and finally to display the read data on the screen.

    The DTS starts with setting some variables with the help of Dynamic properties.
    On Succes.
    DTS rum 2 simultaneous Transform Data task importing data from excel to SQL2000.



    This works fine for "most" of the time, but then there are the other times.
    One of the TDT(Transform Data task) reads nothing from the excel file. but it can read the data if i upload the same file again right after.

    Any kind of input is welcome

    Thanx
    /bs26

  2. #2
    Join Date
    Apr 2003
    Location
    UK
    Posts
    11

    Re: DTS: EXCEL TO SQL: Returns an empty recodset

    Originally posted by bs26
    Hi there,

    I use Asp.Net Application to upload a Excel file and then a DTS to import data from the file to the SQL2000 and finally to display the read data on the screen.

    The DTS starts with setting some variables with the help of Dynamic properties.
    On Succes.
    DTS rum 2 simultaneous Transform Data task importing data from excel to SQL2000.



    This works fine for "most" of the time, but then there are the other times.
    One of the TDT(Transform Data task) reads nothing from the excel file. but it can read the data if i upload the same file again right after.

    Any kind of input is welcome

    Thanx
    /bs26

    It sounds as if you are experiencing a locking problem with the two Transform Data tasks. I have had similar problems with importing and exporting to Access databases.

    Try it with only one TDT and see if it fixes it.

    If you need the additional speed of multiple TDT's, you might try splitting up or duplicating the data over several excel workbooks.

Posting Permissions

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