Post reply

Export table to excel with a varchar max column

  • February 14, 2019 at 10:58 am

    #377020

    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

  • February 14, 2019 at 12:51 pm

    #2022107

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

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

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