We help IT Professionals succeed at work.

SSIS Import flat file with zone signed values

marknicks
marknicks asked
on
Can SSIS flat file connection convert zone signed values?
Comment
Watch Question

Reza RadConsultant, Trainer

Commented:
what do you mean with zone signed values? could you explain more...?

Author

Commented:
It's a hold over from the AS400 days.  -355.50 is expressed as 0000003555{
Reza RadConsultant, Trainer

Commented:
what is your field datatype in flat file connection manager? Is it DT_STR ?

Author

Commented:
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.
Reza RadConsultant, Trainer

Commented:
could you upload your datafile with sample datarows here? I want to check structure of data there

Author

Commented:
Sure.  See attached.
Sample.txt

Author

Commented:
See attached.
Layout.pdf
Sample.txt
Top Expert 2012

Commented:
>>Can SSIS flat file connection convert zone signed values? <<
No.  You will need to write a function to do it.
Consultant, Trainer
Commented:
OK,
SSIS will import any value in your flat file, and doesn't analyze the concept, if you have this format 001355} in your file, ssis will fetch this value exactly, if you want to translate this value to anything else you should use script component to translate it.
Top Expert 2012

Commented:
You are welcome.  I guess you did not need to function I was about to post.  Oh well...

Author

Commented:
I've written one, but would appreciate see yours as you could likely have a more efficient solution.  Thanks for your response.