Data Error in SSIS Data Flow

Question

I continue to get this error...

Error: 0xC002F304 at Data Flow Task - Pull {lead} Changes, CDS Source - Pull {lead} Changes from DynamicsCRM [2]: An error occurred with the following error message: "The input value for 'po_primarybin' field does not fit into the output buffer, please consider increasing the output column's Length property or changing its data type to one that can accommodate more data such as ntext (DT_NTEXT). This change can be done using the component's Advanced Editor window.".

This data column is from Microsoft DynamicsCRM Database and we are trying to push the data into an Azure Table. The Azure Table and its corresponding mapped column [po_primarybin] was originally defined as nvarchar(6).

The Azure Table and data column [po_primarybin] was defined a nvarchar(6). We tried increasing it to nvarchar(50) on the Database and its Advanced Properties and it still failed.

We then added a Data Conversion step to convert the [po_primarybin] coming from DynamicsCRM into a DT_WSTR data column and using that data conversion data column to flow and map into Azure [po_primarybin] and that failed at the same spot...like 7200 rows into the data flow.

Can anyone possibly help me to try and get by this error???

Thanks in advance for your review And am hoping and praying for a reply and a resolution.

Answer 1

Hi @Bobby P，

The input value for 'po_primarybin' field does not fit into the output buffer, please consider increasing the output column's Length property or changing its data type to one that can accommodate more data such as ntext (DT_NTEXT). This change can be done using the component's Advanced Editor window.".

Please check the length of the 'po_primarybin' field, from the error message, the size of the string in the output column is not enough.

Using the component's Advanced Editor window to add the length instead of the destination.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.