Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find a string in SSIS Packages folder Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 12:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 4:00 AM
Points: 27, Visits: 84
Hi,

I have a folder of about 250 packages. I want to find all the packages which have a string '2075' . Please suggest how can I do this. I do not want to open the packages 1 by 1 .

Regards,
Priyanka
Post #1386701
Posted Tuesday, November 20, 2012 12:17 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:09 AM
Points: 870, Visits: 2,385
duggal.priyanka06 (11/20/2012)
Hi,

I have a folder of about 250 packages. I want to find all the packages which have a string '2075' . Please suggest how can I do this. I do not want to open the packages 1 by 1 .

Regards,
Priyanka


With difficulty as there are likely to be numerous occurances of 2075 through out each package and not necessarily the one you re looking for, as they could be descriptions, trace flags, individual attributes, GUIDS, etc.

What is it thats holding the value is it a variable, an SSIS tasks, an Expression?


_________________________________________________________________________
SSC Guide to Posting and Best Practices
Post #1386703
Posted Tuesday, November 20, 2012 12:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 4:00 AM
Points: 27, Visits: 84
It can be a value assigned to a variable or an expression
Post #1386712
Posted Tuesday, November 20, 2012 3:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:38 AM
Points: 165, Visits: 678
Hi,

all packages are XML files, meaning you can search through as text files.
I would suggest you download and install a porgram like textpad (http://www.textpad.com which offers a handy 'Search in Files ...' tool allowing to specify a folder and file types to search through for a specific string.
It then shows you the files containing the string you're looking for.

HTH,

B
Post #1386785
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse