CODEWITHSUNDEEP
ssisscript-component
asd
asd

Reputation: 15

SSIS: Trim some columns w/o doint a Trim in a script component...::::

I have a table with 48 fields, i am filtering some data and need to use a script component( i need this for 10 of the fields in which i am actually changing the data) on the other 38 fields I only want to do a trim. I know i can do this in a script component, but i would rather do it in a more efficient way...Thanks!

Upvotes: 0

Views: 575

Answers (1)

Jeff Hornby
Jeff Hornby

Reputation: 13680

Try using a derived column transformation. If it's really nothing but a trim, you cna even replace the contents of the field without creatingg a new field in your dataflow.

Upvotes: 1

Related Questions