>I am trying to import a table from Excel that has a column that is two chars in lenth. Some of the entries are made up of two numbers, some of a number and a char, and some of two chars. I have formatted the Excel cells as text, and I have made sure that the first entry row is a two char entry, but DTS still is interpreting the column as a INT and does not see the entries that are not just two numbers. How can I get past this?
>
>-- Later - There has not yet been a reply to this message, and I have found a solution.

See also http://www.sqldts.com/default.aspx?254