SSIS Package stalls in validation state : ready to make the following external request: 'IDBInitialize::Initialize'.

Question

I am facing a weird issue: i am triggering the package using Microsoft SQL Server\140\DTS\Binn\DTExecMicrosoft SQL Server\140\DTS\Binn\DTExec. Please help advise. the package log stalls at The object is ready to make the following external request: 'IDBInitialize::Initialize'. no error at the logs or the job elevel JOb level returns no error, job logs shows validation started, validating 0% complete and stops there Detailed logs are as follows DiagnosticEx,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{6DAFB0F4-C4BE-4EE1-A8B6-84522A1D27A2},18/4/2023 12:30:17 PM,18/4/2023 12:30:17 PM,0,0x,<?xml version="1.0"?><DTS:PipelineColumnMap xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Pipeline DTS:Path="\Package\Data Flow Task"><DTS:Column DTS:ID="12" DTS:IdentificationString="Excel Source.Outputs[Excel Source Output].Columns[F1]"/><DTS:Column DTS:ID="13" DTS:IdentificationString="Excel Source.Outputs[Excel Source Output].Columns[F2]"/><DTS:Column DTS:ID="14" DTS:IdentificationString="Excel Source.Outputs[Excel Source Output].Columns[F3]"/><DTS:Column DTS:ID="15" DTS:IdentificationString="Excel Source.Outputs[Excel Source Output].Columns[F4]"/><DTS:Column DTS:ID="21" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[F1]"/><DTS:Column DTS:ID="22" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[F2]"/><DTS:Column DTS:ID="23" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[F3]"/><DTS:Column DTS:ID="24" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[F4]"/><DTS:Column DTS:ID="25" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[ErrorCode]"/><DTS:Column DTS:ID="26" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[ErrorColumn]"/><DTS:Column DTS:ID="41" DTS:IdentificationString="OLE DB Destination.Inputs[OLE DB Destination Input].Columns[F1]"/><DTS:Column DTS:ID="42" DTS:IdentificationString="OLE DB Destination.Inputs[OLE DB Destination Input].Columns[F2]"/><DTS:Column DTS:ID="47" DTS:IdentificationString="OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"/><DTS:Column DTS:ID="48" DTS:IdentificationString="OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"/></DTS:Pipeline></DTS:PipelineColumnMap> Diagnostic,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{6DAFB0F4-C4BE-4EE1-A8B6-84522A1D27A2},18/4/2023 12:30:18 PM,18/4/2023 12:30:18 PM,0,0x,Based on the system configuration, the maximum concurrent executables are set to 4. DiagnosticEx,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{6DAFB0F4-C4BE-4EE1-A8B6-84522A1D27A2},18/4/2023 12:30:18 PM,18/4/2023 12:30:18 PM,0,0x,<?xml version="1.0"?><DTS:ParameterValues xmlns:DTS="www.microsoft.com/SqlServer/Dts"/> OnPreExecute,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{6DAFB0F4-C4BE-4EE1-A8B6-84522A1D27A2},18/4/2023 12:30:18 PM,18/4/2023 12:30:18 PM,0,0x, OnInformation,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{6DAFB0F4-C4BE-4EE1-A8B6-84522A1D27A2},18/4/2023 12:30:18 PM,18/4/2023 12:30:18 PM,1074016266,0x,Validation phase is beginning. Diagnostic,Severname,SCHRODERSAD\service acc,Excel Connection Manager,{1ED93348-90B5-45BB-8A6A-E2ABA2B2177C},{6DAFB0F4-C4BE-4EE1-A8B6-84522A1D27A2},18/4/2023 12:30:18 PM,18/4/2023 12:30:18 PM,0,,ExternalRequest_pre: The object is ready to make the following external request: 'IDataInitialize::GetDataSource(NULL, CLSCTX_INPROC_SERVER, ConnectionString: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\BatchApps\SSIS\GACAutomation\SwiftReport\report.xlsx;Extended Properties="Excel 12.0 XML;HDR=NO";,...)'. Diagnostic,Severname,SCHRODERSAD\service acc,Excel Connection Manager,{1ED93348-90B5-45BB-8A6A-E2ABA2B2177C},{6DAFB0F4-C4BE-4EE1-A8B6-84522A1D27A2},18/4/2023 12:30:18 PM,18/4/2023 12:30:18 PM,0,,ExternalRequest_post: 'IDataInitialize::GetDataSource succeeded'. The external request has completed. Diagnostic,Severname,SCHRODERSAD\service acc,Excel Connection Manager,{1ED93348-90B5-45BB-8A6A-E2ABA2B2177C},{6DAFB0F4-C4BE-4EE1-A8B6-84522A1D27A2},18/4/2023 12:30:18 PM,18/4/2023 12:30:18 PM,0,,ExternalRequest_pre: The object is ready to make the following external request: 'IDBInitialize::Initialize'. OnPreValidate,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:45 PM,18/4/2023 12:30:45 PM,0,0x, OnPostValidate,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:45 PM,18/4/2023 12:30:45 PM,0,0x, PackageStart,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:45 PM,18/4/2023 12:30:45 PM,0,0x,Beginning of package execution. DiagnosticEx,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:45 PM,18/4/2023 12:30:45 PM,0,0x,<?xml version="1.0"?><DTS:PipelineColumnMap xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Pipeline DTS:Path="\Package\Data Flow Task"><DTS:Column DTS:ID="12" DTS:IdentificationString="Excel Source.Outputs[Excel Source Output].Columns[F1]"/><DTS:Column DTS:ID="13" DTS:IdentificationString="Excel Source.Outputs[Excel Source Output].Columns[F2]"/><DTS:Column DTS:ID="14" DTS:IdentificationString="Excel Source.Outputs[Excel Source Output].Columns[F3]"/><DTS:Column DTS:ID="15" DTS:IdentificationString="Excel Source.Outputs[Excel Source Output].Columns[F4]"/><DTS:Column DTS:ID="21" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[F1]"/><DTS:Column DTS:ID="22" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[F2]"/><DTS:Column DTS:ID="23" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[F3]"/><DTS:Column DTS:ID="24" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[F4]"/><DTS:Column DTS:ID="25" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[ErrorCode]"/><DTS:Column DTS:ID="26" DTS:IdentificationString="Excel Source.Outputs[Excel Source Error Output].Columns[ErrorColumn]"/><DTS:Column DTS:ID="41" DTS:IdentificationString="OLE DB Destination.Inputs[OLE DB Destination Input].Columns[F1]"/><DTS:Column DTS:ID="42" DTS:IdentificationString="OLE DB Destination.Inputs[OLE DB Destination Input].Columns[F2]"/><DTS:Column DTS:ID="47" DTS:IdentificationString="OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"/><DTS:Column DTS:ID="48" DTS:IdentificationString="OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"/></DTS:Pipeline></DTS:PipelineColumnMap> Diagnostic,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:46 PM,18/4/2023 12:30:46 PM,0,0x,Based on the system configuration, the maximum concurrent executables are set to 4. DiagnosticEx,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:46 PM,18/4/2023 12:30:46 PM,0,0x,<?xml version="1.0"?><DTS:ParameterValues xmlns:DTS="www.microsoft.com/SqlServer/Dts"/> OnPreExecute,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:46 PM,18/4/2023 12:30:46 PM,0,0x, OnInformation,Severname,SCHRODERSAD\service acc,SwiftAllianceReport,{D6761798-A3F0-4F8B-8D1C-49E8E823A7CA},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:46 PM,18/4/2023 12:30:46 PM,1074016266,0x,Validation phase is beginning. Diagnostic,Severname,SCHRODERSAD\service acc,Excel Connection Manager,{1ED93348-90B5-45BB-8A6A-E2ABA2B2177C},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:46 PM,18/4/2023 12:30:46 PM,0,,ExternalRequest_pre: The object is ready to make the following external request: 'IDataInitialize::GetDataSource(NULL, CLSCTX_INPROC_SERVER, ConnectionString: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\BatchApps\SSIS\GACAutomation\SwiftReport\report.xlsx;Extended Properties="Excel 12.0 XML;HDR=NO";,...)'. Diagnostic,Severname,SCHRODERSAD\service acc,Excel Connection Manager,{1ED93348-90B5-45BB-8A6A-E2ABA2B2177C},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:46 PM,18/4/2023 12:30:46 PM,0,,ExternalRequest_post: 'IDataInitialize::GetDataSource succeeded'. The external request has completed. Diagnostic,Severname,SCHRODERSAD\service acc,Excel Connection Manager,{1ED93348-90B5-45BB-8A6A-E2ABA2B2177C},{377DE989-7C34-451F-8C16-623A7383279B},18/4/2023 12:30:46 PM,18/4/2023 12:30:46 PM,0,,ExternalRequest_pre: The object is ready to make the following external request: 'IDBInitialize::Initialize'.

Answer 1

Hi @Mandal, Anupam，

It seems that you are using DTExec to run the package. There will be a 32bit issue when running the package.

Please try to run the package with 32bit DTExec in Program(x86).

Also try to run the package via VS to see if it could run successfully.

Regards，

Zoe Hui

---

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