Home Forums Data Warehousing Integration Services Search SSIS intance for specific table name RE: Search SSIS intance for specific table name

  • April 26, 2017 at 5:47 am

    #1939916

    bmg002 - Tuesday, April 25, 2017 2:47 PM

    Phil Parkin - Tuesday, April 25, 2017 11:25 AM

    This can't be done. Packages are held in SSISDB in encrypted format.
    An alternative is to use a Windows search tool to search through the package files in your VCS.

    Does windows search search in file contents though for DTSX's?
    I found I needed to use a tool like astrogrep to search through the DTSX's.  But maybe this is better in Windows versions higher than 7 OR I just need to learn how to search better.

    I'm on W10, and from there I see that I could modify my indexing options to include DTSX files.
    But I haven't, because I don't do it that way. Instead, I use FileSeek from Binary Fortress. This is fast and allows Regex matching, which can come in very useful for advanced searches.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.