Share via

Error deployment from SSIS to SQL Server

ikram elmbarki 0 Reputation points
2023-12-13T13:03:32.33+00:00

I tried to deploy project from ssis (visual studio) to SQL server and i got this error :

TITLE: SQL Server Integration Services
------------------------------

A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": 
System.Data.SqlClient.SqlException: The locale identifier (LCID) 14348 is not supported by SQL Server.
System.Data.SqlClient.SqlException: 
   à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   à System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
   à System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)
   à System.Data.SqlClient.SqlDataReaderSmi.NextResult()
   à System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   à System.Data.SqlClient.SqlCommand.ExecuteScalar()
   à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetServerProperty(String propertyName)
   à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetSchemaVersion()
   à Microsoft.SqlServer.IntegrationServices.Server.ISServerExecArgumentBuilder.ToString()
   à Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName)
. (Microsoft SQL Server, Error: 6522)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-6522-database-engine-error

------------------------------
BUTTONS:

OK
------------------------------
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,070 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,486 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
503 questions
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Deployment: The process of delivering, assembling, and maintaining a particular version of a software system at a site.
922 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,577 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,581 Reputation points
    2023-12-14T05:28:36.6833333+00:00

    Hi @ikram elmbarki,

    The locale identifier (LCID) 14348 is not supported by SQL Server

    You may try below methods for a try.

    Method1:
    Go to SSMS-->Go To Security-->Logins-->Right Click on your username and select Properties-->Change the default language to English

    Method2:
    Go to RegEdit -> HKEY_USERS -> [SID Local Admin] -> Control Panel -> International and change keys "Locale" and "LocaleName" for the desired region.

    Method3:
    Go to Windows Services, right click SQL Server (MSSQLSERVER) > properties > Log On > Tick the 'Local System account'. Restart the service by right clicking SQL Server (MSSQLSERVER) again and clicking restart.

    Don't forget to restart SQL Sever.

    Reference: http://www.vdwielen.net/2018/12/ssis-deployment-error-locale-id-lcid.html

    https://stackoverflow.com/questions/21135511/ssis-error-while-deploying-package-the-locale-identifier-lcid-is-not-supported

    Regards，

    Zoe Hui

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

    0 comments