SSIS 物理路径 [英] SSIS physical path

问题描述

我在查找 SSIS 包的物理路径时遇到问题，因为我移交了某人的工作并且 SSIS 中的包名称与光盘中的包名称不同.SSIS 有很多，很难找到正确的.我找到了显示所有包的解决方案，但没有关于物理路径的信息.请停下.

I have a problem with finding the physical path of the SSIS package because I handover someones job and the package name in SSIS is different than in the disc. There are a lot of SSISes and it is hard to find the correct one. I found the solution which displays all packages bu there is no information about physical path. Please halp.

with ChildFolders
as
(
    select PARENT.parentfolderid, PARENT.folderid, PARENT.foldername,
        cast('' as sysname) as RootFolder,
        cast(PARENT.foldername as varchar(max)) as FullPath,
        0 as Lvl
    from msdb.dbo.sysssispackagefolders PARENT
    where PARENT.parentfolderid is null
    UNION ALL
    select CHILD.parentfolderid, CHILD.folderid, CHILD.foldername,
        case ChildFolders.Lvl
            when 0 then CHILD.foldername
            else ChildFolders.RootFolder
        end as RootFolder,
        cast(ChildFolders.FullPath + '/' + CHILD.foldername as varchar(max))
            as FullPath,
        ChildFolders.Lvl + 1 as Lvl
    from msdb.dbo.sysssispackagefolders CHILD
        inner join ChildFolders on ChildFolders.folderid = CHILD.parentfolderid
)
select F.RootFolder, F.FullPath, P.name as PackageName,
    P.description as PackageDescription, P.packageformat, P.packagetype,
    P.vermajor, P.verminor, P.verbuild, P.vercomments,
    cast(cast(P.packagedata as varbinary(max)) as xml) as PackageData
from ChildFolders F
    inner join msdb.dbo.sysssispackages P on P.folderid = F.folderid
order by F.FullPath asc, P.name asc;

推荐答案

我找到了一个解决方法.我刚刚在 Visual Studio 中创建了新的 SSIS 项目，并且可以选择添加现有的 SSIS 包:

I found a workaround to that. I just creatednew SSIS project in Visual Studio and there is an option to add existing SSIS package:

然后我刚刚登录到存储包的服务器:

Then I just logged to a server where packages are stored:

并导航到我正在寻找的包裹.

and navigated to a package I was looking for.

这篇关于SSIS 物理路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！