Hi,
I have a number of packages that are displaying different behaviour when executed within the SSIS-IR environment. That packages run correctly on the development environment using the same source & targets, however when I deployed to the IR and execute I get strange errors that may be related to character encodings or something similar. For example :Invalid character value for cast specification
What are the regional settings used for the SSIS-IR? Could this explain the differences? How can I configure / develop my packages in order to eliminate this type of problem?
Thanks,
John