marknicks
asked on
SSIS Import flat file with zone signed values
Can SSIS flat file connection convert zone signed values?
Reza Rad
what do you mean with zone signed values? could you explain more...?
ASKER
It's a hold over from the AS400 days. -355.50 is expressed as 0000003555{
what is your field datatype in flat file connection manager? Is it DT_STR ?
ASKER
DTR_STR is the only datatype that won't throw an error. I would have thought one of the other datatypes would do the conversion, but if i select one it fails.
could you upload your datafile with sample datarows here? I want to check structure of data there
ASKER
Sure. See attached.
Sample.txt
Sample.txt
ASKER
>>Can SSIS flat file connection convert zone signed values? <<
No. You will need to write a function to do it.
No. You will need to write a function to do it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome. I guess you did not need to function I was about to post. Oh well...
ASKER
I've written one, but would appreciate see yours as you could likely have a more efficient solution. Thanks for your response.