Ok figured out!

Question:
Is there a way for us to have an variable at a higher level ( I mean still we have to go one by one...

Phil, Yes they are deployed!  

RE:  If so, have you investigated using SSISDB environments to control such things
Do you mean environment variables ? Like sgmunson mentioned ?

BTW- Some time back someone gave me this script - WORKED fine! It exports all the DTSX files into a given location. Cool.
if someone out there cam tweak...

Agreed, but here is a problem. You would have to have a separate SERVERfor the config database ?
Note: Each SSIS package ( whether it is in the DEV or...

Sorry, I think I am OK, Managed to make it work....

WITH XMLNAMESPACES( DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' )
Select * FROM
(
SELECT ReportName         = name

This is what I did...
I was hoping someone could come up with something without using LOOPS.
I did mention that replacements must be done only of the character...

Sorry folks! Please ignore this ... I found the solution. It was that simple....
Sorry about my ignorance

IF OBJECT_ID('tempdb..#T') IS NOT NULL
DROP...

I used recursion.. Works Well ! Thanks for the help. See I knew it was easy 

IF OBJECT_ID('tempdb..#MonthlyIntervals') IS NOT NULL
DROP TABLE...