• Why is this so difficult?

    1. Save excel file as CSV

    2. Create flat file connection in SSIS

    3. Click on Advanced tab

    4. Set the value for the required column to STRING (12)

    5. Use a data flow task to import it.

    (If I had access to a web server I could put up some screen captures, but unfortunately, I don't)

    cheers,

    niall