I have a number of SSIS packages, and some of these have a script component in them.  When I invoke the package through BIDS or run it directly by clicking on it, the culture in the package is en-GB.  However, when I invoke this package through an Agent Job, the culture in the package changes to en-US.  The Windows localisation is set to UK, and MSSQL and SSIS are both on the same machine.  Any idea what could be wrong?  Using SQL Server 2008 R2.

• Edited by m1crOch1p Monday, April 07, 2014 8:01 AM

SQL Server used a en-US based collation I guess. You may develop using in BIDS targeting en_US. Or have the package parametrized to be set in its config file to a different locale.

Hi m1crOch1p,

I agree with Arthur that the issue might occur because the LocalID property is changed by package configurations when running in SQL Server Agent job. You can open the job step of the SSIS package execution and check whether any package configurations are specified. If not, open the package in BIDS, and check whether Package Configurations is enabled.

Regards,