title: SSRS Data-Driven Subscription [based on static Subscription table] Not Picking Up Changes Made to Subscription Table
body: <p>I have a <code>.RDL</code> report which I designed in BIDS and have deployed to my report server. The report asks for three parameters before viewing report: <code>Year</code>, <code>Month</code> and <code>Customer ID</code>. The report works great and does exactly what it is supposed to. </p>
  
  <p>While I used to run each report individually because there were 2-3 customers, now there are 30+ customers who receive the report, so I wanted to switch to a more automated fulfillment method to get the reports generated. After doing some research it appears that a using Report Manager to create a "Data Driven Subscription" (DDS) using the "Windows File Share" option gives me the capabilities I need.</p>
  
  <p>As part of creating the DDS, I created a table called <code>[Subscription]</code> which is a table containing one row for each customer receiving the report and has the following columns:</p>
  
  <ul>
  <li>Year </li>
  <li>Month </li>
  <li>CustomerID </li>
  <li>FileName  </li>
  <li>FileLocation  </li>
  <li>Overwrite  </li>
  <li>Format </li>
  </ul>
  
  <p>...so through using the DDS Wizard in Report Manager, I was able to successfully set up a Data Driven Subscription (which is linked to various columns in the <code>[Subscription]</code> table) which creates a new report for each customer in the <code>[Subscription]</code> table, saves [and overwrites, if necessary] it in a location of my choosing as a PDF (specified in <code>[Subscription].[FileLocation]</code>, or the <code>FileLocation</code> column of my table for each row), and runs every minute (I plan on changing frequency to once a week, eventually).</p>
  
  <p>This works flawlessly, giving me a new set of 30 reports in the directory of my choosing, with each report having a name I assigned in the <code>FileName</code> column of my table. Exactly what I was looking for. </p>
  
  <p><strong>HERE'S THE PROBLEM:</strong> When I update the <code>FileLocation</code> or <code>FileName</code> (or anything, really) in the <code>[Subscription]</code> table - it doesn't pick up the changes right away. Sometimes it doesn't even pick it up at all (for example I updated the <code>[ReportName]</code> column for <em>one customer</em> from <code>Report_711622</code> to <code>SpecialReport_711622</code>, so that the output file for that customer should be named <code>SpecialReport_711622</code> while all of the other reports should be called <code>Report_XXXXX</code> [no <code>Special</code> prefix]. <strong>But the file name of report for Customer 711622 remains the same!</strong> </p>
  
  <p>It's almost like the job only see's what it needs to do once a day, and then does not go back and reference the <code>[Subscription]</code> table until I leave for the night, then when I come back in the morning it picks up the change. </p>
  
  <p>Since I am about to scale this process out to a large customer-base using a different report, I need to be able to make edits to the <code>[Subscription]</code> table and have them get picked up by the Data Driven Subscription immediately (and if not immediately, at least a fixed interval of time that I can adjust, so that I can know 100% when the change will get picked up).</p>
  
  <p><strong>Does anyone know what's causing my lag?</strong> How do I change it so that updates to the <code>Subscription</code> table get picked up regularly? I'm also having issues with creating new DDS on other reports (following the exact process outlined above) - I've created the subscriptions, for every minute, and it says they are running and the number of outputs match the number of customers with 0 errors, but there are no files in the drive I specified (or anywhere else I've looked, for that matter).</p>
  
  <p>Any help would be greatly appreciated!</p>