SQL Server Integration Package Failing with Error Code 18883190814 During Execution

Question

System.Data.SqlClient.SqlException: Execution failed with error code <error_code_18883190814>

at Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.Execute()

at Microsoft.SqlServer.Dts.Runtime.TaskHost.Execute(Int32& result)

at Microsoft.SqlServer.Dts.Runtime.Package.Execute()

at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, Boolean loadNeutral)

at Microsoft.SqlServer.Dts.Runtime.PackageItem.Execute(Int32& result)

at Microsoft.SqlServer.Dts.Runtime.PackageEventsProvider.OnError(DtsObject source, Int32 errorCode, String subComponent, String description, String helpFile, Int32 helpContext, String idofInterfaceWithError)

at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100.get_Name()

at Microsoft.SqlServer.Dts.Runtime.Executable.Execute(IDTSContainer container, IDTSExecutionEnvironment env, IDTSEvents events)

at Microsoft.SqlServer.Dts.Runtime.DtsContainer.Execute()

at Microsoft.SqlServer.Dts.Runtime.TaskHostContainer.Execute(Int32& result)

at Microsoft.SqlServer.Dts.Runtime.Executables.ExecuteAll()

at Microsoft.SqlServer.Dts.Runtime.Package.ExecuteAll()

at Microsoft.SqlServer.Dts.Runtime.Package.InternalExecute(Boolean synchronous, IDTSEvents events)

at Microsoft.SqlServer.Dts.Runtime.Package.Execute()

at Microsoft.SqlServer.Dts.Runtime.Package.Execute(Boolean synchronous)

at Microsoft.SqlServer.Dts.Runtime.Package.ExecuteThread()

--- End of stack trace from previous location ---

at Microsoft.SqlServer.Dts.Runtime.Package.FailPackageWithErrorCode(Int32 errorCode = 18883190814

at Microsoft.SqlServer.Dts.Runtime.Package.LogOnError(Int32 errorCode, String description)

at Microsoft.SqlServer.Dts.Runtime.Package.RaiseOnError(String message, Int32 errorCode = 18883190814)

at Microsoft.SqlServer.Dts.Runtime.DtsErrors.Add(String description, Int32 errorCode = 18883190814)

at Microsoft.SqlServer.Dts.Runtime.DtsErrors.AddException(Exception ex)

at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(XmlNode node, IDTSEvents events)

at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromStorage()

at Microsoft.SqlServer.Dts.Runtime.Package.InitializeComponents()

at Microsoft.SqlServer.Dts.Runtime.Package.PrepareForExecution()

at Microsoft.SqlServer.Dts.Runtime.Package.ExecuteTasks()

at Microsoft.SqlServer.Dts.Runtime.Package.ExecuteContainers()

at Microsoft.SqlServer.Dts.Runtime.Package.ExecuteSequence()

at Microsoft.SqlServer.Dts.Runtime.Package.Execute()

at Microsoft.SqlServer.Dts.Runtime.Package.RunPackage()

at Microsoft.SqlServer.Dts.Runtime.Package.Run(Boolean synchronous, IDTSEvents events)

at Microsoft.SqlServer.Dts.Runtime.Package.RunInternal()

at Microsoft.SqlServer.Dts.Runtime.Package.ExecuteOnServer()

at Microsoft.SqlServer.Dts.Runtime.Package.Execute()

Answer 1

Hi Aditi,

The error seems to be a part of your execute statement.

1.Can you locate the Execute SQL Task that is failing or review the SQL query or stored procedure being executed.
2.Check for missing parameters or variables
3.Review package deployment and environment. If the package runs locally but fails on the server, check for differences in SQL Server versions, SSIS runtime versions and Environment variables.

If this still doesn't work, can you please provide more details about the statement you were trying to execute.

Thanks, Shruti