January 12, 2012 at 2:25 pm
Hello All,
I am importing a text file into a table using ssis. There is one column called log_text. It has the data like this
Customer called in to cancel the account. I tried to offer him the speaical rate and informed him of all the Pros to the program. This is his last day of the grace period
When I am previewing it I am getting perfectly. But when I query the table after importing the data is getting truncated. I am getting like this in the column
Customer called in to cancel the account. I trie
The column has the data type as nvarchar(4000) and near the flat file source I have given the size as 8000 for that particular column. But still the data is getting truncated.
Please help.
Thanks
January 12, 2012 at 2:31 pm
Can you describe any transformation components occurring between the source file and the OLEDB destination? Also, can you check the field size settings in the advanced component of the source file datasource?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 12, 2012 at 2:50 pm
I have a data conversion transformation in between. I have set the output column width as 8000 for that column in advanced tab of flat file connection manager. In data conversion transformation I have given the data type as unicode string and size as 4000. In the database I have nvarchar(max) for that column.
January 13, 2012 at 12:06 pm
How have you verified that the data is truncated in the destination table? I could easily see this being a display issue in SSMS, especially with carriage returns and line feeds in the data. And SSMS defaults to a fairly limited number of characters returned to the screen.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply