Solved

How to handle SSIS Validation error 16253?

Posted on 2010-08-20
2
1,983 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
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.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

744 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now