問(wèn)題描述

我有一個(gè) BIDS 套餐.最后的數(shù)據(jù)流任務(wù)"將 SQL 表導(dǎo)出到平面文件.我在此過(guò)程中收到截?cái)噱e(cuò)誤.導(dǎo)出到平面文件時(shí)什么會(huì)導(dǎo)致截?cái)噱e(cuò)誤?錯(cuò)誤發(fā)生在數(shù)據(jù)流任務(wù)"的數(shù)據(jù)流"選項(xiàng)卡下的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".

我已將該列設(shè)置為忽略截?cái)噱e(cuò)誤并且導(dǎo)出工作正常.

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

我理解截?cái)噱e(cuò)誤.我理解為什么將數(shù)據(jù)導(dǎo)入表時(shí)會(huì)發(fā)生這種情況.我不明白為什么在輸出到平面文件時(shí)會(huì)發(fā)生這種情況.

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.

推薦答案

發(fā)生這種情況的原因有很多.請(qǐng)確保下面列出的一些步驟:

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

1) 檢查必須與目標(biāo)數(shù)據(jù)類型匹配的源數(shù)據(jù)類型.如果有不同，它可能會(huì)通過(guò)截?cái)噱e(cuò)誤.

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

2) 檢查是否有塊 :- 您可以通過(guò)在目標(biāo)之前創(chuàng)建數(shù)據(jù)查看器來(lái)檢查這一點(diǎn)，并查看數(shù)據(jù)是否通過(guò).

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

這篇關(guān)于導(dǎo)出到平面文件時(shí)截?cái)?BIDS 包錯(cuò)誤的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！