If you mark your own message as the solution to the thread, please post the solution in the marked message so others may benefit. Typically, if any stars display with a message then the users expect to see a resolution as well.
>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.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"