SSIS 2008 Excel Source - Problems loading Alphanumberic columns?

SSIS uses Jet to access the Excel files. By default, Jet scans the first 8 rows of your data to determine the type of each column To fix it, you will need to edit the registry to increase the TypeGuessRows DWORD value of one of the following registry keys to determine how many rows to scan in your data: It depends on what version of Windows and what version of excel ... as follows: For 32-bit Windows Excel 97 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Excel Excel 2000 and later versions HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel For 64-bit Windows Excel 97 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\3.5\Engines\Excel Excel 2000 and later versions HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel Then, specify “IMEX=1” in the connection string as follows: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\abc. Xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1 This information can be found in a more verbose form at: http://support.microsoft.com/kb/189897.

SSIS uses Jet to access the Excel files. By default, Jet scans the first 8 rows of your data to determine the type of each column. To fix it, you will need to edit the registry to increase the TypeGuessRows DWORD value of one of the following registry keys to determine how many rows to scan in your data: It depends on what version of Windows and what version of excel ... as follows: For 32-bit Windows Excel 97 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Excel Excel 2000 and later versions HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel For 64-bit Windows Excel 97 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\3.5\Engines\Excel Excel 2000 and later versions HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel Then, specify “IMEX=1” in the connection string as follows: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\abc.

Xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1"; This information can be found in a more verbose form at: http://support.microsoft.com/kb/189897.

This is immensely useful information, thanks! – cairnz Mar 10 at 22:24 you are welcome! – Marcus D Mar 14 at 14:11.

Wow, that looks like a huge pain. I came across a couple of examples where you could alter the connection string and sometimes get better results but they don't seem to work for everyone. Scripting an automatic conversion to an .

Csv file would be a good workaround, there are a number of suggestions in this thread: converting an Excel (xls) file to a comma separated (csv) file without the GUI including some code in C# that you may be able to easily plop in: jarloo.com/code/api-code/excel-to-csv/ here is the simiar question where altering the connection string is discussed if you want to look into it for yourself: SSIS Excel Import Forcing Incorrect Column Type Good luck!

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.