July 21, 2016 at 2:26 am
Hi,
We are having a source column CustomerLID (nvarchar) and need to load this into CustomerLID (Unique Identifier).
Source 'CustomerLID' column is having the data(ex: "d57b487b-373a-481e-b7a8-760637a8b07a") which is equivalent to UniqueIdentifier format. So we have been loading the data by simply converting this CustomerLID column in DT_GUID without using any '{','}' braces from last 5 months sucessfully.
But suddenly our package got failed due to this conversion error saying "The value could not be converted because of a potential loss of data".
I have identified the error data and verified the length and its format. Everything this is similar to unique identified format.
Later I have added "{"+CustomerLID+"}" in derived column and loaded successfully into the target table.
Why we need to add the "{,}" even though the data in my source table in similar to unique identifier format?
Why my package got failed suddenly which is being running from several months with out any issues?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply