Azure SQL Db中的sysssislog表 [英] sysssislog table in Azure SQL Db

问题描述

我已经创建了SSIS包，该包用于将数据从Excel Sheet存储到Azure DB.

I have created the SSIS package using which I am storing data from Excel Sheet to Azure DB.

我已经创建了一个指向Azure SQL DB的OLE DB连接管理器，并希望在其中存储日志记录信息.我已经在SSIS包中配置了日志记录信息.运行该软件包后，我无法查看sysssislog表 因为系统数据库下没有msdb数据库

I have created a OLE DB Connection manager pointing to the Azure SQL DB and want to store the logging information there. I have configured the logging information in SSIS package. After running the package I am not able to look into the sysssislog table as there is no msdb Database under System Database

我查看了系统数据库，那里只有主数据库.

I looked into System Database there exist only master DB.

请帮助我

谢谢

Pankaj

推荐答案

你好，

Hello,

请考虑配置Azure集成服务.

s/sql/integration -services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view = sql-server-2017

https://docs.microsoft.com/zh-cn/azure/data-factory/how-to-invoke-ssis-package-ssis-activity (在这里配置基本或自定义日志记录)

Please consider configuring Azure Integration Services.

https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-2017

https://docs.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-ssis-activity  (here you configure basic or custom logging)

https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-connect-to-catalog-database?view=sql-server-2017

希望这样做帮助.

问候

Regards,

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于Azure SQL Db中的sysssislog表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！