• Hi Sam,

    If you can use third-party solutions, check the commercial COZYROC SSIS+[/url] library. It contains Excel adapters which support more than 256 columns.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/