从平面文件将管道分隔的数据加载到SQL表时，SSIS错误. [英] SSIS error while loading pipe delimited data from flat file to SQL table.

问题描述

报价:

我正在查看现有的sis软件包.
我从源代码管理中下载了该软件包.更改连接管理器以指向我的本地
开发环境.
任务是从平面文件读取并在Sql Db上加载.

文件是"|"定界的平面文件.在连接管理器中，标题行定界符已设置为{LF}.

执行任务时，我遇到了几个错误，其中之一是

[curr用户文件[2]]错误:数据转换失败.列的数据转换
"customfield_storeid"
返回状态值4和状态文本目标代码页中的文本被截断或一个或多个字符不匹配.".

我查看了连接管理器，将列设置为string [DT_STR]并将OutputColumnWidth设置为50.

在我的数据库表中，对于该列，它是varchar(50).因此，似乎没有任何错误.



如果我可以更改错误输出以忽略截断错误，则不会显示错误.
但是我不想更改以前为程序包设置的内容.

我该如何解决?

I am looking at existing ssis package.
I download the package from source control. Change connection managers to point to my local
dev envirionment.
Task is to read from Flat file and to load on Sql Db.

File is ''|'' delimited flat file. In connection manager, Header row delimiter has set as {LF}.

While executing task, I ran into several error and one of that is

[curr user file [2]] Error: Data conversion failed. The data conversion for column
"customfield_storeid"
returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

I looked into the connection manager, column has set to string[DT_STR] and OutputColumnWidth to 50.

In my DB table, for that column , it is varchar(50). So it seems there is not anything wrong.



If I could change error output to ignore truncation error, it would not show error.
But I do not want to change what has previously set for the package.

How do I resolve it ?

我尝试过的事情:

What I have tried:

I looked into the connection manager, column has set to string[DT_STR] and OutputColumnWidth to 50.

推荐答案

尝试更改数据转换组件中的长度

谢谢

Hi,

Try to change the length in Data conversion component

Thanks

这篇关于从平面文件将管道分隔的数据加载到SQL表时，SSIS错误.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！