InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 08:14:48 GMT20http://www.sqlservercentral.com/Forums/Topic708637-1371-1.aspxHonestly, never tried (but I would think no). Sorry, haven't dealt much with SSIS packages. Try a search string that you know is in an SSIS package and see if it brings back any results. Post the results if you don't mind.Thu, 18 Oct 2012 11:15:09 GMTSean Smith-776614http://www.sqlservercentral.com/Forums/Topic708637-1371-1.aspxI'm not clear if this will allow for searches within SSIS packages?Thu, 18 Oct 2012 06:31:30 GMTDouglas Osborne-229812http://www.sqlservercentral.com/Forums/Topic708637-1371-1.aspxGood idea and thanks for posting this. I may end up adding a "use or search" for wildcards switch in a later version. This would make it more flexible.Tue, 03 Jul 2012 17:36:29 GMTSean Smith-776614http://www.sqlservercentral.com/Forums/Topic708637-1371-1.aspxNo problem. That works fine for me, just needed to figure it out and wanted to let everyone else know how to pass the search string parameter to the stored procedure so they don't run into the same thing.Tue, 03 Jul 2012 17:10:38 GMTTim Edwards-235208http://www.sqlservercentral.com/Forums/Topic708637-1371-1.aspxWhen I originally designed the procedure it actually functioned the way you wanted it to. After a peer review with some colleagues, they all argued for the opposite (never can win it seems LOL). Since you've familiarized yourself with the code you should be able to adjust it to fit your needs.Thanks for the feedback.Tue, 03 Jul 2012 16:00:02 GMTSean Smith-776614http://www.sqlservercentral.com/Forums/Topic708637-1371-1.aspxI think it is worth noting that the @v_Search_String parameter should not contain any wildcards (i.e., %) as the stored procedure adds that to the parameter. I didn't realize that at first and was not getting anything back on my test system when I knew the string existed. Going through the code, I quickly discovered that the wildcards are added to the string in the parameter for you and my adding them caused it to read the wildcard as a literal character that was part of the search string.Tue, 03 Jul 2012 15:27:27 GMTTim Edwards-235208http://www.sqlservercentral.com/Forums/Topic708637-1371-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/object/66798/">Object Search</A>[/B]Fri, 01 May 2009 11:49:09 GMTSean Smith-776614