September 22, 2017 at 7:56 am
Hello,
I have an excel file which as some fields. The fiels are as str, but when I do the below derived column expression (even converting to str) the fields appear as unicode
expression: ISNULL([HEDGE CLASS CODE]) ? (dt_str,100,1252)"FundCode" : (DT_STR,100,1252)"FundCode_SHC"
May someone help me undertand the issue?
Thanks,
Pedro
September 22, 2017 at 8:24 am
What do you mean "the field"? Do you mean [HEDGE CLASS CODE]? That column will remain a dt_wstr, as you can't "change" the data type of a column in SSIS,, however, you introduce new columns and remove older ones. These new columns can have different datatypes to those that they are derived from. So the new column you've added will be of the data type dt_str, but [HEDGE CLASS CODE] will still be a dt_wstr.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 24, 2017 at 11:35 pm
Greetings,
Please review the following Web site: (setting up the SSIS package should be done as explained in this site.)
Please test your solution in a test computer.
Regards,
DBASupport
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply