Post reply

DTS dropping chars at 255

  • December 4, 2009 at 6:43 pm

    #214356

    I have a DTS job setup to drop/create tables and download data from a MySQL database on a hosted server. One of the fields I am downloading is a text field that frequently has more then 255 chars in it. During the DTS download, all values in this field get cut off at 255 chars. This is a problem because this field contains survey comments and my users need to see the entire lenght of the field.

    Is there a fix for this? I tried converting and casting the field to a varchar(1000) but that did not work. Then I tried populating the first 8 rows of this column with values greater than 255 chars thinking it used the first 8 rows as a sample. This also did not work.

    Thanks,

    C

  • December 5, 2009 at 2:32 am

    #1088137

    Triple post.

    Please start discussion here

    Note: duplicating a thread after just 10 minutes, then yet another one after just two more minutes probably is even less a good way to get an answer...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 5, 2009 at 10:23 am

    #1088179

    Yes, I am aware of the triple post and I apologize. It was unintentional and this forum does not allow me to delete my posts. When I created the topic I got a "page cannot be displayed" error at ... sqlservercentral.com/Forums/Topic829324-5-1.aspx?Update=1.

    When I refreshed the page to try and bring it up in the browser, it re-posted my topic two times. I did not know it was doing that. Please delete the two duplicate topics and keep the one where Jeff responded to me. This is a legitimate thread.

    Thanks,

    C

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

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