DTS: EXCEL TO SQL: Fails to Imports data once in a while

[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

 

[GoBrowns]

Hi, I am interested in doing this as well. Any tips you can give me on uploading the excel file and then programmatically naming the datasource in the DTS. Also, did you ever find a solution as to why it only worked most of the time

Thanks
GoBrowns

 

[bs26]

Hi GoBrowns,

Sorry For not responding a bit earlier as I had my hands filled a copule of assignment, which had to be out of the door.

I didn't find out why it sometimes didn't work. But is has been months it last occured. It happens once in a blue moon.

It would be quite helpful for me to guide you to the best of my abilities if I knew it bit more about your scenerio.

/bs26