title: SSIS - varchar(max)
body: <p>I have sp which concatenate a long string and which passes back to SSIS. but currently SSIS is only picking the string partially. </p>
  
  <p>Is there a method which allows the a T-SQL stored procedure to pass a long string to SSIS ? Currently the parameter is defined as <code>VARCHAR(max)</code></p>
  
  <p>I tried using a SSIS Object variable and it does not allow me to convert it back to string. How do I convert a SSIS Object to string</p>
  
  <pre><code>Convert.ToString(Dts.Variable["ObjVar"]Value) ; 
  </code></pre>
  
  <p>I am using SSIS 2012.</p>
  
  <p>Thanks</p>