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.

DTS if .. do somthing

How I can do If instruction in DTS ??

example

select @.data=date form table where id=32

if @.data='2007-10-22'

copy data to exel from table2 (I have this in 3 elements(OLE DB Source,Data Conversion,Flat File Destination)

else

do nothing

I don't now how to do if instraction.

Pleas help me.

FYI - Did you know that DTS has been deprecated, and that SSIS is the new approach?

|||I have register my dts in sql server ...|||

Don't use an if statement, build the conditional logic into the where clause of your select statement.

select * from select table where id=32 and date='2007-10-22'

Copy whatever is found in the next step in the process flow. If no data is found, nothing will be copied.