The string geting truncated

Question

The string geting truncated

kanth.vishal

SSC Journeyman

Points: 93
More actions
March 25, 2010 at 12:35 pm

#218498

Hello ,
I have to import a string of 100 character into the database table column having data type varchar and 1000 character limit.
I have used following (DT_STR,1000,1252)TRIM([Column 18])
column18 is the column in the txt file having data .
My question is that using above expression I am not able to export complete string of 1000 character into database column
for eg: the input file has following input string:
Email in place of inspection. Inside of house is finished and siding to be done when weather clears. Hoping to be finished April 2008.
but when I look into database column after conversion I am able to see only following line:
Email in place of inspection. Inside of house is
and not the complete sentence

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

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

John Rowan SSC Guru Points: 56440 More actions · Answer 1

So the data source is a text file? Is it using a flat file connection manager? If so, open up the connection manager and go to the Advanced tab and look at the properties of your column 18. What is the data type and input/output column widths?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

kanth.vishal SSC Journeyman Points: 93 More actions · Answer 2

Yes the source file is a text file and it is using Flatfile connection manager .The data type is string[DT_STR] and width input column width is 0 (read only) and output column width is 50

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

Add a data viewer after you get your initial data, if is complete there, add the data viewer further down and keep going until you at least have the task that is the culprit. The problem may not be exactly where you think it is.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

kanth.vishal (3/26/2010)
Yes the source file is a text file and it is using Flatfile connection manager .The data type is string[DT_STR] and width input column width is 0 (read only) and output column width is 50

Set the output width to 1000 instead of 50.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

John Rowan SSC Guru Points: 56440 More actions · Answer 5

First off, I appologize for letting this one get away from me.

Secondly, adjust the column properties as da-zero suggests. Your column needs to match the destination column. Having it set to 50 is why your data is getting truncated.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

kanth.vishal SSC Journeyman Points: 93 More actions · Answer 6

Thanks for helping me out on this. I have set the output column width it is working absolutely fine:-)