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
– Gerardo, Commented May 10, 2017 at 22:52

Hadi · Accepted Answer · 2017-05-12 12:29:21Z

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, 2017 at 12:29

answered May 10, 2017 at 22:56

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Gerardo Over a year ago

I do it, and I double click on the destinaion but I still getting warning

Hadi Over a year ago

What is the warning message. Handover the mouse on the warning mark to see it

Hadi Over a year ago

may be it is another one

Gerardo Over a year ago

I check it and is the same warning as I post

Hadi Over a year ago

Check that you have used the derived column not the source.

Wendy · Accepted Answer · 2017-05-11 17:08:12Z

1

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

answered May 11, 2017 at 17:08

Wendy

6601 gold badge4 silver badges8 bronze badges

Collectives™ on Stack Overflow

Change data length using SSIS DerivedColumn

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related