Unicode Data Export - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Unicode Data Export

Author

Topic

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-11-28 : 06:32:27

I have a unicode data in my database and i wants to exports it in Flat file.But i am getting this error
"[Flat File Destination [117]] Error: Data conversion failed. The data conversion for column "Copy of file_path" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

I have this structure
image_id uniqueidentifier
image_file varbinary(max) --contains filestream
file_path nvarchar(500) --contains unicode string

any help regarding this will be appreciated.

thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-28 : 07:21:19

whats the length you've given for it. looks like its below its max length which is why it errors telling that truncation will occur

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-11-28 : 07:38:11

The Max len is

MAX(LEN(file_path)) = 54
max(Datalength(file_path)) =108

While it does not truncate the data instead it gives the error "[Flat File Destination [117]] Error: Data conversion failed. The data conversion for column "Copy of file_path" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-28 : 07:39:21

are you trying to move it to non unicode field?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-12-03 : 02:16:47

i m trying to move it in Flat File

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-03 : 02:18:29

quote:
Originally posted by sagitariusmzi

i m trying to move it in Flat File

by any chance did you modify type of any of columns in table?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-12-03 : 02:23:57

I have this structure of sql server DB and i am trying to export it in Flat file, the data it contains is filesteam(images) and urdu characters. when i try to export only filestream, it exported successfully but when i included nvarchar column it given the error specified.

I have this structure
image_id uniqueidentifier
image_file varbinary(max) --contains filestream
file_path nvarchar(500) --contains unicode string

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-03 : 02:32:04

quote:
Originally posted by sagitariusmzi

I have this structure of sql server DB and i am trying to export it in Flat file, the data it contains is filesteam(images) and urdu characters. when i try to export only filestream, it exported successfully but when i included nvarchar column it given the error specified.

I have this structure
image_id uniqueidentifier
image_file varbinary(max) --contains filestream
file_path nvarchar(500) --contains unicode string

check if code page used in ssis supports urdu characters

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2011-12-03 : 02:48:21

i didn't changed any code page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources