CODEWITHSUNDEEP
sql-serverssis
Mohit Kumar
Mohit Kumar

Reputation: 21

Can we trim the text stream [DT_TEXT] lnput column length to 1000 characters in SSIS before sending it to output column

I am new to SSIS so please bear with me.

I have a external column in my SSIS package with text stream [DT_TEXT] data type (length 0) the output column is string [DT_STR] (length 1000).

Is there a way to trim the length of external column text stream [DT_TEXT] to 1000 before sending to output.

Any help will be really appreciated.

I have tried Advanced Editor Column length column is disabled(as obvious) for text stream [DT_TEXT] data types.

Any input will be really appreciated. Thanks

Upvotes: 2

Views: 1823

Answers (1)

Tanner
Tanner

Reputation: 22753

You probably want to take a look at using a Data Conversion Transformation Editor:

Use the Data Conversion Transformation Editor dialog box to select the columns to convert, select the data type to which the column is converted, and set conversion attributes.

You can set the input column, output alias, data type and length. This would then produce a new aliased column in the new type.

This link provides sample of how this can be achieved:

SSIS Data Conversion

You can see how various input columns are being transformed, with an output Data Type and Length.

enter image description here

Upvotes: 3

Related Questions