Export table to excel with a varchar max column

  • Marv_SQL


    Points: 1612


    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?


  • doug.brown


    Points: 5561

    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