March 30, 2009 at 1:20 pm
Truncation may occur due to retrieving data from database column "XXXXX" with a length of 50 to data flow column "XXXXXX" with a length of 20.
I copied a data flow so I didn't need to re-add all the components. I changed the data source queries as needed for the new data flow. There is a column name that was the same as the previous data flow. I am now getting the warning from above. Would the lineage ID's stay the same even though I entered a new query? Also I didn't think column names actually identified anything that is why I question if the lineage ID's remain.
There is no chance of truncation between the source and destination. The warning seems to indicate that SSIS will truncate based on the settings from the previous data flow.
Does this make any sense? I've copied components before and never ran across this one.
Is there a way to edit the data flow column or refresh the meta-data.
thanks - Tom
March 30, 2009 at 1:51 pm
I think what happened was the new query had the same column name in the same position as it did in the previous query so it did retain the same lineage ID. I added an alias to that column and it generated a new lineage ID with the meta-data of the current query definition, then mapped the components to the new lineage ID and the warning went away.
- tom
August 30, 2010 at 9:50 am
This looks like the same issue I am having. Where did you add the alias? SSIS/DB?
August 30, 2010 at 11:44 am
In my source components I always use SQL statements for the source query, this is where I would have put the alias. HTH - tom
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply