DTS Import data problem (exel into SQL server 2000)

Hi all,

I face a small problem in DTS, hope you can help me to solve this issue.

I designed a DTS package to import excel data ( with 4 column ) into SQL server database,The database design for the database table was

column name type length

ID bigint 8

CountedQty decimal 9

Location nvarchar 8

Other nvarchar 50

The DTS package is work and does not appear any error message. But the data in column 'Location' appeared <Null> after import into the database, this issue happen when the excel data was <numeric> value (string value in this data column can be accepted and appear nicely).

Izzit because nvarchar cannot accept numeric value, how can i solve this problem ?

Thank you very much.

flreStarter

hi,

are you place up a log file for that DTS? Even in the own pump task you can enable a specific log in order to obtain further details.