Export table to excel with a varchar max column

  • Marv_SQL

    SSCommitted

    Points: 1612

    Hello,

    I'm trying to create an ssis package that exports a table from SQL Server 2012 to Excel, but the package fails everytime I run it because one of the columns of the table has a varchar max. I believe excel's max is 255.

    Are there any workarounds for this?

    Thanks

  • doug.brown

    SSCertifiable

    Points: 5526

    Would it work to change your select for that field to something like LEFT(Field, 255)?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply