December 2, 2011 at 11:39 am
I'm using SSIS and hte following Data Flow objects: Excel->Data Conversion->ADO NET Destination. I am getting the BELOW errors and am unable to resolve even though in the Data Conversion Data Converstion Output properties I have set
InvoiceOwner to Unicode string [DT_WSTR] 15
Vendor to Unicode string [DT_WSTR] 64
Vendor# to four-byte signed integer [DT_I4.
Can you please advise on how to solve this blocker! Thanks in advance.
[ADO NET Destination [229]] Warning: Truncation may occur due to inserting data from data flow column "Invoice Owner" with a length of 255 to database column "InvoiceOwner" with a length of 15.
[ADO NET Destination [229]] Warning: Truncation may occur due to inserting data from data flow column "Vendor" with a length of 255 to database column "VendorName" with a length of 64.
[ADO NET Destination [229]] Warning: Potential data loss may occur due to inserting data from input column "Vendor #" with data type "DT_R8" to external column "VendorNumber" with data type "DT_I4". If this is intended, an alternative way to do conversion is using a Data Conversion component before ADO NET destination component.
December 2, 2011 at 11:46 am
Discovered source of problem was that once I created copies of original columns (in Data Converstion object) with new datatypes I needed to return to Excel DataFlow object and remap from Copy of columns.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply