Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Changing datatype problem in derived column in SSIS 2008 Expand / Collapse
Posted Tuesday, October 13, 2009 5:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 4, 2009 3:35 PM
Points: 25, Visits: 161
Hello Friends,

In my office, i am using SSIS 2008, and in one data flow task i have taken one derived column transformation and added one new column of type string.

it is taking default data type as Unicode string, and i want to change it as string data type, but it is not changing. actually, all the datatype listing should come in dropdown box, but the dropdown box is not coming. but in SSIS 2005 we can change the data type using drop down box.

is this the feature was restricted in SSIS 2008 or is there any problem with my software?

please suggest me in this regard.

Sathish B
Post #802075
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse