I have developed a SSIS package on my Client Machine which imports an Excel
sheet. I have it working fine on my client. When I move it to the SQL Server
2005 machine in Development and run the package I get a column data type
issue on a Field that the data type was a text stream on my CLient PC. I
copied all of the code up to the development server and opened the package up
in VS 2005 and hover my mouse over the column in question and it says it is a
string field with a 255 character limit.
Why is the VS 2005 environment on the development server reporting the same
excel sheet field as a different field type. There doesn't seem to be a way
to modify it. I assume when the excel connection is made it determines the
field type. I am confused why it is reporting difeerent between my CLient pc
and the server. I have SP1 installed on both.

I just figured out the problem:

There is a Registry key for Jet 4.0
Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/TypeGuessRows

which on my CLient was set to 19 hex or 25 decimal

On the Server it was set to 8. I changed the server to 19 hex and then VS
2005 on the server looked at the excel file and determined the column was a
text stream instead of a string.

Hope this helps someone else one day because this caused me such a massive
headache.

Scott


"Scott" wrote: