title: SSIS - DB Destination Dynamic Table Name
body: <p>After creating tables A, B, C with Control Flow in ssis package, reading Excel with Data Flow.
  I want to put the data in tables A, B, C generated after processing.</p>
  
  <p>Control Flow (Create table (A,B,C)) -> Data Flow (Read Excel File -> split -> insert table (A,B,C))</p>
  
  <p><strong>Control Flow</strong></p>
  
  <p><img src="https://i.stack.imgur.com/MqQX6.png" alt="enter image description here"></p>
  
  <p><strong>Data Flow</strong></p>
  
  <p><img src="https://i.stack.imgur.com/qJOUO.png" alt="enter image description here"></p>
  
  <p><strong>Create Question Table SQL Script functoid</strong></p>
  
  <p><img src="https://i.stack.imgur.com/7459h.png" alt="Question table"></p>
  
  <p><strong>Destination error message</strong></p>
  
  <p><img src="https://i.stack.imgur.com/DPwhU.png" alt="Invalid object error"></p>
  
  <p>I think that Dynamic Table is necessary.  please help you how to connect to .</p>