I did a quick DST using an excel price sheet and found allot of nulls
when I have a column general in the sheet having ONLY a numeric value.


If the column has 442**TDF it's fine.
But the same column in the same pull with 2 gives a NULL.

This is a pricing file that is going to send to a print shop for other
use, so I can't really expect any rule I want to be applied by the
marketing department.

TIA

__Stephen

DST? Is that DTS?

Are you seeing this?

Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"srussell705" <srussell (AT) lotmate (DOT) com> wrote

Thanks!!!!

That was the issue. And yes DTS and not an old employer DST of mine
__Stephen

I have currently trying to import an excel spreadsheet with named cells to
SQL thr DTS..

My problem is that how to I skip those cell that are empty in the
spreadsheet using DTS activeX?

This is what I tried? (I have tried checking for isNull)

Function Main()
'Check for not Null
If trim(DTSSource("Field A"))=NULL Then
Main = DTSTransformStat_SkipRow
Else
DTSDestination("FIELD_A") = DTSSource("Field A")
end if
Main = DTSTransformStat_OK

End Function

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks for the invitation.

"Stephen Russell" wrote:

Sorry about that. I thought that my message went through??

Go to this page for the registry fix.

<http://www.sqldts.com/default.aspx?6,222,254,0,1>

Seems that the data engine only looksa at the first 8 rows of the sheet.
This will fix that for you.

__Stephen




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I have tried the methods suggested in the article. But it does not help.

As I do not know how many rows does the spreadsheet has, hence is there
a way to check if the cell is empty?

I noticed that as long as the cell has a border it is not consider
empty. Any where to overcome that? I hope to provide an excel
spreadsheet, with formulas and formatting to my user to perform data
entry.

thanks.

~ oriki9999 ~


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!