title: Using dynamic Server and Database Name in SQL Server stored procedure over linked servers
body: <p>I have a requirement.
  Using SSIS i am import data from flat file/excel file into my staging table. From staging table i need to filter data and transfer it to different databases over different linked server.i.e. let say for California i have dbCalifornia  on Server A, For Taxes i have dbTaxes on Server B etc etc.
  I need to read config table and redirect data accordingly.i.e. if column value =CALI insert data in dbCalifornia.tblA, for column value =TAX insert data in dbTaxes.tblA. I am trying to use Server Name and Database name   as variable (because i am reading these from config table) i.e. </p>
  
  <pre><code>INSERT INTO [@server].[@database].[DBO].[BASIC]
  </code></pre>
  
  <p>But i am getting error .
  I am not expert DBA please suggest my solution how can i implement this scenario.</p>
  
  <p>TIA</p>