读取大型Excel文件时的SSIS零星错误。意外终止
我们有一个SSIS流程，该过程使用OLEDB Excel连接器从Excel文件中消费数据。该代码可靠地成功地消耗了文件并将其写入我们的数据库中。
但是，在过去6个月中，发生了两次零星的失败。 该过程只是停止运行，而Integration Services目录显示状态意外终止。没有报告错误消息，因此我们不会进一步射击。
如果我只是重新运行该过程，它可以正常工作，并且它将继续工作多个月。
该过程通常会循环，并消耗大约60或70个Excel文件，大小变化， 通常大约有20至70 MB的大约20个左右的文件。 （理想情况下，我们不应该处理大型的Excel文件，但这是来源提供商给我们的。我肯定会更喜欢CSV或其他内容。）
正在使用的连接字符串： 提供者= microsoft.ace.oledb.16.0;数据源= C：\ bla \ bla \ blabla \ sourcefile.xlsx; extended properties =“ excel 12.0 xml; hdr;代码>
来自Windows的错误消息：
故障应用程序名称：Isserverexec.exe，版本：14.0.3436.1， 时间戳：0x6234EB8A故障模块名称：MSO99LWIN32CLIENT.DLL， 版本：16.0.5239.1001，时间戳：0x617113AF例外代码： 0xc000041d故障偏移：0x0000000000181DEA故障过程ID：0xAD0 故障应用程序开始时间：0x01D87C5510D88ED0错误 应用程序路径：C：\ Program Files \ Microsoft SQL 服务器\ 140 \ dts \ binn \ isserverexec.exe故障模块路径：c：\ program 文件\ common Files \ Microsoft共享\ Office16 \ MSO99LWIN32CLIENT.DLL 报告ID：BDD23F34-1A78-445C-B134-96935AB43ED0故障包装完整 姓名：错误软件包相关应用程序ID：
该过程通常有效。但是，在Windows事件日志中记录了上述错误，偶尔会失败。
我搜索了，没有发现任何相关的东西。任何想法或指示都将不胜感激。
问候 Aamer
We have an SSIS process which consumes data from Excel files using the oledb excel connectors. The code runs reliably successfully consuming the files and writing them to staging in our DB.
However there is a sporadic failure which has occurred twice in the last 6 months.
The process simply stops running, and the Integration Services Catalog shows the Status Unexpected Termination. There is no error message reported so we aren't able to trouble shoot further.
If I simply rerun the process it works fine and it will continue to work for many months.
The process usually loops through and consumes about 60 or 70 excel files, varying in size,
there are usually about 20 or so large files of 40 to 70 MB.
(Ideally we should not be dealing with excel files that big, but that is what the source provider gives us. I would prefer CSV's or something else for sure. )
The connection string being used :Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\bla\blabla\sourcefile.xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES;IMEX=1;MAXSCANROWS=104567";
The error msg from windows:
Faulting application name: ISServerExec.exe, version: 14.0.3436.1,
time stamp: 0x6234eb8a Faulting module name: mso99Lwin32client.dll,
version: 16.0.5239.1001, time stamp: 0x617113af Exception code:
0xc000041d Fault offset: 0x0000000000181dea Faulting process id: 0xad0
Faulting application start time: 0x01d87c5510d88ed0 Faulting
application path: C:\Program Files\Microsoft SQL
Server\140\DTS\Binn\ISServerExec.exe Faulting module path: C:\Program
Files\Common Files\Microsoft Shared\Office16\mso99Lwin32client.dll
Report Id: bdd23f34-1a78-445c-b134-96935ab43ed0 Faulting package full
name: Faulting package-relative application ID:
The process normally works. But sporadically fails with the above error logged in the windows event log.
I have searched and not found anything relevant. Any ideas or pointers would be greatly appreciated.
Regards
Aamer
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论