导出到平面文件时截断 BIDS 包错误

2021-09-10 00:00:00 sql tsql sql-server bids

我有一个 BIDS 套餐.最后的数据流任务"将 SQL 表导出到平面文件.我在此过程中收到截断错误.导出到平面文件时什么会导致截断错误?错误发生在数据流任务"的数据流"选项卡下的OLE DB"元素中.

I have a BIDS package. The final "Data Flow Task" exports a SQL table to Flat File. I receive a truncation error on this process. What would cause a truncation error while exporting to flat file? The error was occurring within the "OLE DB" element under the Data Flow tab for the "Data Flow Task".

我已将该列设置为忽略截断错误并且导出工作正常.

I have set the column to ignore truncation errors and the export works fine.

我理解截断错误.我理解为什么将数据导入表时会发生这种情况.我不明白为什么在输出到平面文件时会发生这种情况.

I understand truncation errors. I understand why they would happen when you are importing data into a table. I do not understand why this would happen when outputting to a flat file.

推荐答案

发生这种情况的原因有很多.请确保下面列出的一些步骤:

This might be occurring for many reasons. Please make sure some of the steps listed below:

1) 检查必须与目标数据类型匹配的源数据类型.如果有不同,它可能会通过截断错误.

1) Check the source Data types that has to match with destination data type. If there are different it might through Truncation Error.

2) 检查是否有块 :- 您可以通过在目标之前创建数据查看器来检查这一点,并查看数据是否通过.

2) Check if there are blocks :- You can check this by creating Data viewer before the Destination and see the data come through.

相关文章