要比较同一SSIS包的执行,可以使用SQL Server Management Studio (SSMS) 和 Integration Services Catalogs。
下面是一些示例代码,可以帮助您开始比较同一SSIS包的执行:
-- 获取包执行结果的查询
SELECT *
FROM SSISDB.catalog.executions
WHERE package_name = 'YourPackageName'
ORDER BY start_time DESC
-- 获取包执行步骤结果的查询
SELECT *
FROM SSISDB.catalog.executable_statistics
WHERE execution_id IN (
SELECT execution_id
FROM SSISDB.catalog.executions
WHERE package_name = 'YourPackageName'
)
ORDER BY execution_id, start_time
-- 获取包执行结果的查询
SELECT *
FROM [SSISDB].[catalog].[executions]
WHERE [package_name] = N'YourPackageName'
ORDER BY [start_time] DESC
-- 获取包执行步骤结果的查询
SELECT *
FROM [SSISDB].[catalog].[executable_statistics]
WHERE [execution_id] IN (
SELECT [execution_id]
FROM [SSISDB].[catalog].[executions]
WHERE [package_name] = N'YourPackageName'
)
ORDER BY [execution_id], [start_time]
请注意,上述示例中的"YourPackageName"应替换为要比较的SSIS包的名称。