Post reply

Search and Find in SSIS?

  • August 25, 2014 at 1:18 pm

    #311029

    Hi,

    I have recently taken over the SSIS packages from a colleague who left the company.

    I am trying to look for a task that was disabled. Looking at that package will provide me some more information as in the items that were being passed through this package.

    But, i cant seem to find it.

    For example if the package uses "SQLXYZ" in its sql code, is there a tool that i can use to do a find and search on this text?

    I am a vba coder, and i use search and find a lot.

    Please advice.

    Thanks,

  • August 25, 2014 at 1:20 pm

    #1740829

    nsaxena9 (8/25/2014)

    Hi,

    I have recently taken over the SSIS packages from a colleague who left the company.

    I am trying to look for a task that was disabled. Looking at that package will provide me some more information as in the items that were being passed through this package.

    But, i cant seem to find it.

    For example if the package uses "SQLXYZ" in its sql code, is there a tool that i can use to do a find and search on this text?

    I am a vba coder, and i use search and find a lot.

    Please advice.

    Thanks,

    If its only for one package, you can right click on the package , then view code. this will open the code in XML.

    then you can use the normal find and replace commands.

    thanks

    rm

  • August 25, 2014 at 1:23 pm

    #1740831

    If you want to look in a single package, you can right click on the package (inside BIDS) and select "View Code". That will show the xml and you can search the text in there. The problem is that you need to identify the location.

    For multiple packages, you can use Notepad++ and it's "Search in Files" function. Other tools might do that as well, but that's the one I use.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • August 25, 2014 at 1:30 pm

    #1740836

    Thank you both!

    I found what I needed.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply