sql server dts: Hi Ava,

"Ava" <Ava@discussions.microsoft.com> schrieb im Newsbeitrag
news:C7A4C9D7-2247-49E2-9FF9-43B9E4378FE4@microsoft.com...
[quoted text, click to view]

this is a common problem.
Look here for explanation and solution.
http://www.sqldts.com/default.aspx?254
http://support.microsoft.com/default.aspx?scid=kb;EN-US;194124
In addition I would like to mention that the TypeguessRows value only allow
16 as max value.
So you have to be sure your different types exist in at least the first 16
rows, or you have to set the value to 0, which forces the driver to scan all
rows.
Because scanning all rows of a real big excel file is not a good idea, you
should also think about inserting dummy rows at top to force the right
detection.

Helge

I have mixed data in one Excel column (integer and string). If the integers
on the top I can only import integers and all string values will be NULL. If
the string values on the top I can only import strings but the integers will
be NULL. Is there any way to import mixed data?