_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › SsisdbQuery

with pkg
as
(
select distinct 
    a.name project_name
,   b.name package_name
from ssisdb.internal.projects a
    inner join ssisdb.internal.packages b
        on a.project_id = b.project_id
)
select b.*
from pkg aa
    cross apply (
        select 
            b.name
        ,   c.created_time
        from ssisdb.internal.projects a
            inner join ssisdb.internal.packages b
                on a.project_id = b.project_id
            inner join ssisdb.internal.object_versions c
                on b.project_version_lsn = c.object_version_lsn
        where 1=1
        and a.name = aa.project_name
        and b.name = aa.package_name
        --and c.created_time between '20190410' and '20190425'
    ) b


select 
    b.*
,   c.created_time
--,   c.object_data
from ssisdb.internal.projects a
    inner join ssisdb.internal.packages b
        on a.project_id = b.project_id
    inner join ssisdb.internal.object_versions c
        on b.project_version_lsn = c.object_version_lsn
where 1=1
and a.name = 'dw'
and b.name = 'dim.test.dtsx'
谿瑚
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2019-04-26 17:34:36

讌蠍蟾讌 襷れ 覲 蟆一 豺蟲襯 螳讌 . ( )