Thanks for the reply. I have used a combination of the RS utility, RSS file, VBscript, IS package and some database tables to replicate the data driven subscription functionality. Note we are on the SQL 2005 Standard Edition.
We have about 25 distinct reports that get run each month for each of our 20 branches and exported as a pdf. Each report has its own unique list of parameters. Some are dependent on the branch ie they may have a different commission rate%. Some reports are run for more than one item in the parameter list of values eg Category A,B,C. I have created a package that loops through each report, gets the branch(s) that requires the report, then gets each parameter for the report and branch combination from the DB, creates an RSS and BAT file dynamically and then executes the BAT file for each branch exporting a PDF file to the YYYYMM/Branch name folder.
I will definitely try you method. Thanks