問題描述
我有一個 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.
這篇關于導出到平面文件時截斷 BIDS 包錯誤的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！