I'm trying to import data from Excel 2000 file with DTS in MSSql2000. I keep
getting NULL values during import.

I have been using this post mostly
http://www.sqldts.com/default.aspx?254
I've been trying to use the third option of using an ActiveX script. But it
doesn't have any effect for me. If I enter invalid data source name it will
give me error message.


I changed the registry and the import worked fine
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel\TypeGuessRows
= 0. But I hate to change resigtry on other peoples machine. Is there a way
to change the
registry TypeGuessRows in DTS while the package runs and then back again
after is finishes?

I think everybody hates to do this as well but I don't know that if you were
able to do this in the package and then change it back that it would be any
better, What if the package fails?



--



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


"Mike" <Mike (AT) discussions (DOT) microsoft.com> wrote

Well, if I change verything back to original way I get the nulls, then if I
change
the registry to 0 I will not get nulls. But I was hoping for a pure DTS
answer. If
the package fails then nothing happens.

"Allan Mitchell" wrote: