SSIS Packages Deployment to SQL Server getting Error

Ivan Raditya 51 Reputation points
2022-07-06T02:52:06.84+00:00

Hi Everyone

I need some help..

I try to deploy my package to SQL Server and already have the catalog in SQL Server.
My package only contain Procedure and Import Excel process.

But I am getting this error and could not find any solution.

I try to search about this exception but no luck

Unrecognized configuration section system.web/system.web.  
(C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 243)  

Here is the full error message

A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal":   
System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.   
---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception.   
---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception.   
---> System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize   
---> System.Configuration.ConfigurationErrorsException: Unrecognized configuration section system.web/system.web.  
(C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 243)  
System.Configuration.ConfigurationErrorsException:   
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)  
   at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)  
   at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)  
System.Configuration.ConfigurationErrorsException:   
   at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)  
   at System.Configuration.ClientConfigurationSystem.PrepareClientConfigSystem(String sectionName)  
   at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)  
   at System.Configuration.Co  
    ...  
System.TypeInitializationException:   
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString)  
   at Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetOperationInfo(SqlInt64 operation_id, OperationType type, ServerOperationStatus status, Int64& object_id)  
   at Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.checkParameters(SqlInt64 object_id, SqlInt64 operation_id, OperationType type)  
   at Microsoft.SqlServer.IntegrationServices.Serve... (.Net SqlClient Data Provider)  
  
------------------------------  
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.7001&EvtSrc=MSSQLServer&EvtID=6522&LinkId=20476  
  
------------------------------  
Server Name: database  
Error Number: 6522  
Severity: 16  
State: 1  
Procedure: deploy_project_internal  
  
  
------------------------------  
Program Location:  
  
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)  
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)  
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)  
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)  
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)  
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)  
   at 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)  
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)  
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()  
   at Microsoft.SqlServer.IntegrationServices.Common.ObjectModel.SqlHelper.ExecuteSQLCommand(SqlStoreConnection storeConnection, CommandType cmdType, String cmdText, SqlParameter[] parameters, ExecuteType execType, Int32 commandTimeout)  
   at Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder.DeployProject(String projectName, Byte[] projectStream)  
   at Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeployExportProjectHelper.DeployProject(CatalogFolder folder, Project project)  
   at Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeploymentModel.Deploy(CatalogFolder folder, Project project)  
   at Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeploymentModel.DeployProject()  
   at Microsoft.SqlServer.IntegrationServices.Deployment.DeployProjectPage.DoWork(Object sender, DoWorkEventArgs e)  
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)  
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)  
  

Here is my SSIS and SQL Server Version
217973-image.png
217991-image.png

Hope for help
Thanks!

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,644 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 40,586 Reputation points
    2022-07-06T07:08:57.513+00:00

    Hi @Ivan Raditya ,

    What's the version of your SQL Server?

    Have you set the target server the same as yours in the package?

    Please also try to deploy packages by using SQL Server Management Studio to see if it will work or not.

    1.In SQL Server Management Studio, expand the Integration Services Catalogs > SSISDB node in Object Explorer.

    2.Right-click the Projects folder, and then click Deploy Projects.

    3.If you see the Introduction page, click Next to continue.

    4.On the Select Source page, switch to Package Deployment model. Then, select the folder that contains source packages and configure the packages.

    You may refer to deploy-integration-services-ssis-projects-and-packages for details.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. ZoeHui-MSFT 40,586 Reputation points
    2022-07-07T01:18:54.01+00:00

    Hi @Ivan Raditya ,
    You may use select @@version to check the version of the SQL Server which you are connecting.

    Make sure that the TargetServerVersion in your package is same as the SQL Sever which has the SSIS catalog.

    It seems that your package version is lower than the server.

    From online research, to deploy SSIS packages to SQL Server 2012 you need to build and deploy from VS 2010 or 2012.

    1 person found this answer helpful.
    0 comments No comments

  2. Ivan Raditya 51 Reputation points
    2022-07-07T04:03:33.497+00:00

    Hi @ZoeHui-MSFT

    Is there anyway to open or use packge from my version to 2012?
    Or I need to rebuild the package?

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.