Import export failed : Data conversion failed

[Source - chn_employee_vew_test_txt [1]] Error: Data conversion failed. The data conversion for column "Column 42" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

[Source - chn_employee_vew_test_txt [1]] Error: The "output column "Column 42" (136)" failed because truncation occurred, and the truncation row disposition on "output column "Column 42" (136)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

I using Locale (People's Republic of China) and code page of 936 (Simplied Chinese GBK) with header row delimiter {CR}{LF}.

I am using flat file import method.

Whenever the server process the Column 42 with value "11,Nanjing Rd.W, China" which contain 'comma' or '.' it will hit error importing with above message. When i manually change the column value to non comma or '.' (11 Nanjing Rd W China) in the flat file it is ok.

I am using SQL server 2005.

Please advise what need to be done to avoid this error ?

Thanks in advance and any idea or suggestion is very much appreciated as i have try to solve this issue for over a week but still not able to find any answer on it.

Please help.

regards,

kong

Check the Quoted_Identifier and text_qualifier values in SSIS, if you are running from a workstation then make sure SSIS server component is installed

Import Data Status

Dear all,
I need to copy data from one DB to another DB using the Import Data
function. When I started the transfer, it ran for a certain period then
stopped at around 50% of progress for few hours. The status shown in the
dialog is 608, another case is showing 703. What is the meaning of the
statuses? How can I get reference information about the statuses?
Thanks for any help!
Tedmond
Tedmond
I have no idea about these statuses . Consider using T-SQL to copy the data
between the databases
INSERT INTO db1.dbo.Table1 (col1,col2....) SELECT col1,col2.... FROM
db2.dbo.Table2
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:234701C5-E121-4499-B291-3432C8917DA6@.microsoft.com...
> Dear all,
> I need to copy data from one DB to another DB using the Import Data
> function. When I started the transfer, it ran for a certain period then
> stopped at around 50% of progress for few hours. The status shown in the
> dialog is 608, another case is showing 703. What is the meaning of the
> statuses? How can I get reference information about the statuses?
> Thanks for any help!
> Tedmond
>

Import Data Status

Dear all,
I need to copy data from one DB to another DB using the Import Data
function. When I started the transfer, it ran for a certain period then
stopped at around 50% of progress for few hours. The status shown in the
dialog is 608, another case is showing 703. What is the meaning of the
statuses? How can I get reference information about the statuses?
Thanks for any help!
TedmondTedmond
I have no idea about these statuses . Consider using T-SQL to copy the data
between the databases
INSERT INTO db1.dbo.Table1 (col1,col2....) SELECT col1,col2.... FROM
db2.dbo.Table2
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:234701C5-E121-4499-B291-3432C8917DA6@.microsoft.com...
> Dear all,
> I need to copy data from one DB to another DB using the Import Data
> function. When I started the transfer, it ran for a certain period then
> stopped at around 50% of progress for few hours. The status shown in the
> dialog is 608, another case is showing 703. What is the meaning of the
> statuses? How can I get reference information about the statuses?
> Thanks for any help!
> Tedmond
>

Import Data Status

Dear all,
I need to copy data from one DB to another DB using the Import Data
function. When I started the transfer, it ran for a certain period then
stopped at around 50% of progress for few hours. The status shown in the
dialog is 608, another case is showing 703. What is the meaning of the
statuses? How can I get reference information about the statuses?
Thanks for any help!
TedmondTedmond
I have no idea about these statuses . Consider using T-SQL to copy the data
between the databases
INSERT INTO db1.dbo.Table1 (col1,col2....) SELECT col1,col2.... FROM
db2.dbo.Table2
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:234701C5-E121-4499-B291-3432C8917DA6@.microsoft.com...
> Dear all,
> I need to copy data from one DB to another DB using the Import Data
> function. When I started the transfer, it ran for a certain period then
> stopped at around 50% of progress for few hours. The status shown in the
> dialog is 608, another case is showing 703. What is the meaning of the
> statuses? How can I get reference information about the statuses?
> Thanks for any help!
> Tedmond
>