title: SQL Server 2008 Synonym <name> refers to an invalid object
body: <p>I am trying to call a stored procedure from SSIS.</p>
  
  <p>One line of the code is </p>
  
  <pre><code>select *
  FROM dbo.syn_tab_myTable
  </code></pre>
  
  <p>I can actually see this <code>dbo.syn_tab_myTable</code> sitting in my <code>Synonyms</code> folder. However, I've got following error:</p>
  
  <blockquote>
    <p>Error: 0xC002F210 at SQL Build tab_Stats, Execute SQL Task: Executing
    the query "build.proc_build_stats ?" failed with the following error:
    "Synonym 'dbo.syn_tab_myTable' refers to an invalid object.". Possible
    failure reasons: Problems with the query, "ResultSet" property not set
    correctly, parameters not set correctly, or connection not established
    correctly.</p>
  </blockquote>
  
  <p>Then I just started a new query that I do the <code>select</code> operation again, but still I got this:</p>
  
  <blockquote>
    <p>Msg 5313, Level 16, State 1, Line 1 Synonym 'dbo.syn_tab_myTable'
    refers to an invalid object.</p>
  </blockquote>
  
  <p>There are other synonyms in the same folder, while some of them appear in the drop list when I type the name, and some of them don't.</p>
  
  <p>I have no idea what is causing this problem. Please help! Thanks.</p>