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

  • April 25, 2017 at 2:47 pm

    #1939845

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

    dan-572483 - Tuesday, April 25, 2017 11:00 AM

    Is there a way to search a SQL2012 Integration Services instance for SSIS jobs that update a specific table?

    Can I complete this query to get what I'm looking for?
    USE SSISDB
    select * from ???
    where ??? like '%<table name>%'

    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.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.