Post reply

SSIS - How to Set Output column width to varchar(max)

  • May 9, 2009 at 1:29 pm

    #132139

    I have an SSIS project that works fine on files smaller than 8k.

    When i use a file larger than 8k, it fails due to a truncation error.

    I have tracked the issue to the 'set column width' which is limited to 8000.

    How do i change the 'set column width' field to varchar(max) and get around my issue ?

    BTW some of my input files are 35k.

    Thanks

  • May 11, 2009 at 6:23 am

    #992034

    I have searched the internet for a solution, but no luck.

    This seems very easy, but for some reason poorly documented.

    Has anyone else experienced this ? What is a workaround solution ?

    Thanks

  • May 11, 2009 at 6:46 am

    #992048

    Since varchar(max) replaces text data type, does changing the input column type to text work?

  • May 11, 2009 at 6:58 am

    #992060

    behind the scenes, the length is set to -1 for the column in syscolumns. can you set the width to -1 instead of 8000?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 11, 2009 at 9:29 am

    #992216

    Changing to -1 did not work, but changing to text format worked!

    Many thanks for your assistance 😀

  • February 15, 2019 at 5:59 am

    #2022140

    You can put 8000 since it is the value that cannot be reached by VARCHAR(MAX)

Viewing 6 posts - 1 through 5 (of 5 total)

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