DTS char(880) export returns only 255 characters

Question

DTS char(880) export returns only 255 characters

August Savi

SSC Veteran

Points: 204
More actions
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.

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

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

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

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 !!!**

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 2

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

DSP-120308 Hall of Fame Points: 3959 More actions · Answer 3

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

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

Good Luck,

Darrell

August Savi SSC Veteran Points: 204 More actions · Answer 4

Thank You!

Problem was with OLE-DB "hidden features".

alpoor reddy Mr or Mrs. 500 Points: 515 More actions · Answer 5

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

August Savi SSC Veteran Points: 204 More actions · Answer 6

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!

alpoor reddy Mr or Mrs. 500 Points: 515 More actions · Answer 7

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

August Savi SSC Veteran Points: 204 More actions · Answer 8

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.

alpoor reddy Mr or Mrs. 500 Points: 515 More actions · Answer 9

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