March 14, 2011 at 5:55 pm
I pull certain data from Orcale DB by querying where it has 3 columns say A(size 5),B(size 10),C(size10).
and this maps to table in sql DB where a table is created with 3columns A(5), b(10), c(5)..
... my problem is everything is fine but ....i want to fix this truncation warnings...
i tried in using derived column ...but couldn't figured it out
March 14, 2011 at 6:26 pm
In your derived column, try: (DT_STR,5)substring([ColumnName],1,5)
You have to force the data down directly to fit your result.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 15, 2011 at 8:04 am
But i tried doing as you mentioned...but still the warnings exists...it says "TRUCATION may occurs DUE TO INSERTING DATA FROM DATA FLOW COLUMN, "COLUMN B " WITH LENGTH OF 10 TO DATABASE COLUMN " COLUMN B" WITH LENGTH OF 3"
March 15, 2011 at 8:20 am
quillis131 (3/15/2011)
But i tried doing as you mentioned...but still the warnings exists...it says "TRUCATION may occurs DUE TO INSERTING DATA FROM DATA FLOW COLUMN, "COLUMN B " WITH LENGTH OF 10 TO DATABASE COLUMN " COLUMN B" WITH LENGTH OF 3"
Two things:
1) It seems that you are trying to map your source column directly rather than mapping your derived column. You need to amend your mappings.
2) Try using this as your derived column formula:
(DT_STR,3) substring([Column B],1,3)
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply