sql imports null values from excel

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql imports null values from excel

Author

Topic

mayurgogia
Starting Member

3 Posts

Posted - 2009-01-14 : 04:07:31

Hi,

I have following values in my excel field:

2,12,13,15,24,45,77,80,1A,1B,1G,1H,2J,2M,3E,4V,4W,4Z,5E,8F,8T,AD,BJ,BK,BL,CE,CM,CN,H1,HE,PW,QC,QI,QV,QW,QX,R1,RM,RO,RP,S1,SP,TG,TJ,TK,TW,WC,WN

I have a DTS Package in SQL 2000 running to import them. But it is importing the following:

QW,2J,WN,RM,4Z,QX,TJ,PW,TG,BJ,1B,CN,RO,5E,SP,BK,CE,1A,CM,4W,QI,BL,1H,8T,HE,AD,8F,R1,4V,RP,3E,QC,2M,NULL,WC.

Unimported values are replaced by NULL. but the count is same.

When i try CAST inside the DTS, it throws error

"HResult of 0x80004005(-2147467259) returned. Unexpected error occured."

Any help?????????

Mayur Gogia

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-01-14 : 06:44:29

is there a formulae or reference defined for the cell which is getting imported as NULL ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-14 : 08:39:43

how are you trying to import using script task or data transformation task?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources