Error message SSIS: The LocalID 9 is not installed on this system.

Question

Hi,

I get the error message "The LocalID 9 is not installed on this system.", when I change in the "Flat file Connection Manager" > Local: from Dutch to English.
I try to make a connection with a CSV file.

I have tried to change the LocalID in the package, flat file connection manager and Flat file source at properties. Like suggested in this topic:
https://social.msdn.microsoft.com/Forums/en-US/d858dfdf-188a-440d-83bb-f954a1f9f909/ssis-tutorial-lesson-1-cant-change-localid?forum=sqlintegrationservices

However, I am unable to get it work.

Can somebody please help me? Thank you!

Error message:
TITLE: Package Validation Error

---

Package Validation Error

---

ADDITIONAL INFORMATION:

Error at Data Flow Task [SSIS.Pipeline]: The LocaleID 9 is not installed on this system.

Error at Data Flow Task [SSIS.Pipeline]: "Flat File Source" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

---

BUTTONS:

OK

---

Answer 1

Hi @ZenGra34Den ,

Welcome to the microsoft SSIS Q&A forum!

Please try the following:
Step 1:
Go to the Project Properties as shown below.

Step 2:
In the Configuration Properties check if the Target SQL version is set to correct version.

Step 3:
If still not working set the SQL Server to a lower version than your current version.

For more details, please refer to:
How to solve “The Locale ID 9 is not installed on this system” error in SSIS
Locale ID not installed in the system | Locale ID cannot be matched with the Connection Manager Locale ID

If you have any question, please feel free to let me know.

Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.