title: dynamic filename for raw destination occurs error in ssis
body: <p>Am using few variables to load csv file value into raw destination, and same variables from raw source to oledb destination.</p>
  
  <p><b>variables List</b></p>
  
  <pre><code> 1. CurrentFileName--&gt; FX Accrued Income_20120111_161019.CSV     
  2. FilenamePrefix--&gt; it has expression ( ((DT_STR, 4, 1252)DATEPART("yyyy", (DT_DATE) @[User::AsOfDate] ) + RIGHT("0" + (DT_STR, 2, 1252)DATEPART("mm", (DT_DATE)@[User::AsOfDate]), 2) + RIGHT("0" + (DT_STR, 2, 1252)DATEPART("dd", (DT_DATE)@[User::AsOfDate]) ,2))  )    
  3. AsOfDate--&gt; 01/20/2012    
  4. Sample Output --&gt; C:\satish\New Folder\     
  5. stagingouputpath--&gt;  it has expression ((RIGHT( @[User::sampleoutput] ,1) == "\\" ? @[User::sampleoutput] : @[User::sampleoutput] + "\\")  + SUBSTRING( @[User::CurrentFileName] ,1, FINDSTRING( @[User::CurrentFileName],".", 1) ) + "RAW"    )   
  </code></pre>
  
  <p>Now in raw destination ---> i have given access mode has from varibale and  variable name as stagingoutputpath</p>
  
  <pre><code>&lt;b&gt; raw destination   
  acess mode--&gt; from variable  
  filename--&gt; stagingouputpath  
  write option--&gt; create always &lt;/b&gt;
  </code></pre>
  
  <p>and next level i need to use this ouput destination as input variable for raw source and load it into sql destination..</p>
  
  <pre><code>destinaton table contains fields like  
  report_dir, reportpatternname, processtype,
  
  now i need to insert this raw source file name to reportpatternnname   
  example   
  reportdir--C:\satish\New Folder  
  reportname--FX Accrued Income
  </code></pre>
  
  <p>in destination table </p>