Dave C. - Friday, August 18, 2017 1:52 PM
Regional settings - go to control panel and then Regional and Language settings. Refer to this -
How to: Change Operating System Settings to Support Localized Versions
To find the code page being used - open the command prompt as administrator, type in chcp and it will report the code page.
Refer to this to see what the values are:
Code Page Identifiers
To get database collations, you can use this: select name, collation_name
from sys.databases
I wouldn't change anything if you find any differences though.
What is not working? You said "converting characters not supported by our iseries". Converting from where to where and which is failing? Are you importing to iseries, exporting to iseries, from where to where? It may not have anything to do with what was suggested and you could definitely hose out more than your SSIS packages.
Sue