question

ZenGra34Den-9463 avatar image
0 Votes"
ZenGra34Den-9463 asked EchoLiu-msft edited

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

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



sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EchoLiu-msft avatar image
0 Votes"
EchoLiu-msft answered EchoLiu-msft edited

Hi @ZenGra34Den-9463,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.