Post reply

DTS char(880) export returns only 255 characters

  • June 2, 2005 at 3:17 am

    #163849

    How to export all characters from DB field char(880) to text file?

    Now only 255 characters will be exported.

     

  • June 2, 2005 at 6:11 am

    #562474

    Here's something that should help:

    DB-Library applications and applications using the SQL Server ODBC drivers from SQL Server version 6.5 or earlier support only a maximum of 255 bytes of character data. If these applications attempt to retrieve character parameters of SQL Server version 7.0 or later, or result set columns containing more than 255 bytes of data, the character data is truncated at 255 bytes.







    **ASCII stupid question, get a stupid ANSI !!!**

  • June 2, 2005 at 6:21 am

    #562479

    I would also check the variables, etc.. that are used to create the export file and ensure that they are not set to be 255 (believe me, I've done it AND seen it)



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • June 2, 2005 at 8:20 am

    #562537

    Here is some more information on adjusting the size of the text file columns.

    http://www.sqldts.com/default.aspx?297

     

    Good Luck,

    Darrell

  • June 2, 2005 at 9:22 am

    #562598

    Thank You!

    Problem was with OLE-DB "hidden features".

     

  • June 2, 2005 at 5:11 pm

    #562747

    I have same problem, Please let me know how you fix it

     

  • June 3, 2005 at 3:07 am

    #562810

    1. Open package in Design view;

    2. From Package menu choose Disconnected Edit;

    3. From Connections select connection corresponding to text output;

    4. From OLE-DB properties find property named Max characters per delimited column;

    5. The value is probably set to 255, change it to bigger value.

    That will put things to work!

     

  • June 3, 2005 at 6:18 am

    #562838

    I did samething as you mentioned couple of times but no luck. Am I missing something. By the way, I am trying to export data from Lotus Notes database

  • June 3, 2005 at 3:44 pm

    #563022

    Then maybe there is something with Lotus Notes connection properties?

    Can You import data from Lotus Notes to some table in SQL server and then make query against it and look if data is imported correctly? For example use LEN to find out how many characters in this field.

    If there also data is missing then problem must be in Lotus Notes connection.

  • June 4, 2005 at 11:30 am

    #563078

    I finally found the problem. I forgot to configure NOTES SQL ODBC driver where it says TEXT Field Length = 256, this has to be set to whatever numbner you. I set this lenght on destination source side as menioned in previous post but not on Originating source. It worked great after I set it to some 2000 chars

     

    Thanks to all

     

Viewing 10 posts - 1 through 9 (of 9 total)

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