November 20, 2012 at 12:09 am
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
November 20, 2012 at 12:17 am
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
November 20, 2012 at 12:49 am
It can be a value assigned to a variable or an expression
November 20, 2012 at 3:26 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply