the column prefix '.' does not match
1. select table full name
2. add ligin propertiel
[SQL][SSIS]List for SQL Server SSIS project and packages name
SELECT
b.[name] as [專案名稱]
,a.[name] as [dtsx名稱]
FROM SSISDB.catalog.packages as a
left join SSISDB.catalog.projects as b on a.project_id = b.project_id
order by b.[name] asc ,a.[name] asc
訂閱：
文章 (Atom)