问题描述
全部，
运行SSIS包的ADF管道引发错误'没有提供临时缓冲存储位置。缓冲区管理器将考虑TEMP和TMP环境变量中的目录。
程序包从数据库中提取大约10,000行并将其转储到Excel中
为了解决这个问题，我将网络共享分配给：
BLOBTempStoragepath = \\company.com\SSISBlob
缓冲区 TempStoragepath = \\company.com\SSISBuffer
部署完毕后;我现在收到错误
"SsisDBOperationGuid"：""，&b $ b "SsisDBOperationId"：''，
"OperationErrorMessages"："'外部组件引发了异常。; 在Microsoft.SqlServer.Dts.Runtime.DtsContainer.Execute（Connections连接，变量变量，IDTSEvents100事件，IDTSLogging100
日志，对象事务）\\ nn 在Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ISServerExecutionEvents.StartPackage（）\\\
4 / 30/2019 3:36:53 PM +00：00：外部组件抛出异常。\ n"，
"effectiveIntegrationRuntime"："SSIS IR Name"和"SSIS IR Name"。 （美国东部2）"，
" executionDuration"：""
任何想知道可能修复的内容的人？
谢谢，
Joseph
BI开发人员
All,
The ADF pipeline running an SSIS package threw the error 'No temporary buffer storage locations were provided. The buffer manager will consider the directories in the TEMP and TMP environment variables'.The package is pulling about 10,000 rows from database and dumping it in Excel
To fix that I assigned a network share to:
BLOBTempStoragepath = \\company.com\SSISBlob
BufferTempStoragepath = \\company.com\SSISBuffer
After deploying this ; I am now getting error
"SsisDBOperationGuid": "",
"SsisDBOperationId": '',
"OperationErrorMessages": "' External component has thrown an exception.; at Microsoft.SqlServer.Dts.Runtime.DtsContainer.Execute(Connections connections, Variables variables, IDTSEvents100 events, IDTSLogging100 log, Object transaction)\r\n at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ISServerExecutionEvents.StartPackage()\n4/30/2019 3:36:53 PM +00:00 : External component has thrown an exception.\n",
"effectiveIntegrationRuntime": "SSIS IR Name" (East US 2)",
"executionDuration": ""
Anyone with the idea of what is going on an possible fix?
Thanks,
Joseph
BI Developer
这篇关于意外终止 - 未提供临时缓冲存储位置。缓冲区管理器将考虑TEMP和TMP环境变量中的目录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！