Change data length using SSIS DerivedColumn

Question

I´m reading .csv file to paste into sql table but I get advertesiment into a column

It occurse because my destination table have "MOLDE" with string(50) and source have string(255)

How can I change "MOLDE" length to get only 50 first values

So I create derived column and I try to use substring, but it keep getting length 255

What can I do there?. Regards

----UPDATE----

I´m resolve it as answer comment but I still getting Advertisiment Icon like this:

Is it posible to remove it?

Yes it works, but cann you view my update in my question please? @bjones — Gerardo, May 10 '17 at 22:52

Hadi · Accepted Answer · 2017-05-12T12:29:21.847

2

Try casting to DT_STR with length equal 50

(DT_STR,50,1252)SUBSTRING(MOLDE,1,50)

OR

(DT_STR,50,1252)LEFT(MOLDE,50)

Note that you have to map the derived column to the destination instead of the original column , if warning still appearing just double click on the destination to refresh metadata

Reference

https://learn.microsoft.com/en-us/sql/integration-services/expressions/cast-ssis-expression

UPDATE 1

After reading your comment i think the warning still appearing because you have selected derived column option to replace the original column which caused this conflict, just change the option Replace 'MOLDE' to Add New Column and map the derived column to the destination column.

Or make sure that the destination is reading MOLDE column from the derived column component not the Source column, openning Destination with advanced editor may help.

edited May 12 '17 at 12:29

answered May 10 '17 at 22:56

Hadi

36,233
13
65
124

I do it, and I double click on the destinaion but I still getting warning – Gerardo May 11 '17 at 16:39
What is the warning message. Handover the mouse on the warning mark to see it – Hadi May 11 '17 at 16:52
may be it is another one – Hadi May 11 '17 at 17:22
I check it and is the same warning as I post – Gerardo May 11 '17 at 18:15
Check that you have used the derived column not the source. – Hadi May 11 '17 at 18:32

score 1 · Answer 2 · answered May 11 '17 at 17:08

1

Right click your warning icon, chose Show Advanced Editor, input and output properties tab, check your column length there.

answered May 11 '17 at 17:08

Wendy

640
1
4
8

Change data length using SSIS DerivedColumn

2 Answers2