Solved

How to handle SSIS Validation error 16253?

Posted on 2010-08-20
2
2,086 Views
Last Modified: 2013-11-10
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.  

The issue:
I now have an error on this task that reads:

Error      5      Validation error. dimActivity: Slowly Changing Dimension [16253]: 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?

Thanks!
0
Comment
Question by:safair
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 400 total points
ID: 33490334
change ActivityDesc to DT_WSTR datatype
you can do this with :
data conversion transformation
or
with advanced editor of source and changing the output column type in input/output columns tab.
0
 
LVL 1

Assisted Solution

by:da-zero
da-zero earned 100 total points
ID: 33490890
A little bit off-topic: using a SCD technique is the way to go, but using the standard SCD component from SSIS isn't. It is notoriously slow for updates, as it issues a single UPDATE statement for each row. It is better to implement the SCD yourself in SSIS using T-SQL, or to use the Kimball SCD from Codeplex.

Regarding your actual problem: convert it to DT_WSTR, as reza_rad suggested. In the destination database you have to create a (N)VARCHAR(MAX) column.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question