How to handle SSIS Validation error 16253?
Posted on 2010-08-20
I'm new to SSIS 2005 (I usually load via T-SQL). I've added a dimension table to the database that has an identity colulmn that is used to create the Key number rather than use the source's ID column.
In SSIS, I added a Data Flow task that is used to load the data from a view of the source table (created using a linked server). I have a Slowly Changing Dimension data flow item so that the process doesn't add another set of records each time. I just want to add the new ones and update the edited ones and I was told this was the way to do it. It this is not the way to do it, let me know.
I now have an error on this task that reads:
Error 5 Validation error. dimActivity: Slowly Changing Dimension : The "input column "ActivityDesc" (16956)" has a long object data type of DT_TEXT, DT_NTEXT, or DT_IMAGE, which is not supported.
ActivityDesc in the source is ntext which, obviously, isn't supported in the Slowly Changing Dimension.
What is the recommended way to handle this situation?