title: How can I create SSIS using stored procedure?
body: <p>A group in my company granted me access to execute a stored procedure, and the stored procedure, if executed from excel, gives me a table. I want to store this table in SQL via SSIS. </p>
  
  <p>I tried this via:
   Within DFT, I created a connection using SQL Server Native Client. And within source assissstant, I entered SQL command </p>
  
  <pre><code>EXEC     [dbname].[storedprocedure]
  </code></pre>
  
  <p>But then it returns an error:</p>
  
  <pre><code>No column information was returned by the SQL command.
  </code></pre>
  
  <p>Is there anyway to make this work?</p>