title: How to fix error : Multiple-step OLE DB operation generated errors. Check each OLE DB status value
body: <p>I am passing variable value as input parameter to a script in execute sql task. Its a string variable in package having value C:/Archive</p>
  
  <p>The input parameter data type is varchar in parameter mapping in execute sql task.</p>
  
  <p>script in execute sql task is  </p>
  
  <pre><code>Declare @body1 nvarchar(max), @b nvarchar(max)
  
  set @body1 = 'The softdollar error files are located at '
  set @b =  @body1 + ?
  
  EXEC msdb.dbo.sp_send_dbmail 
  @profile_name='PWO Notification',
  @recipients='JoJo@foo.com',
  @subject= 'Soft Dollar Package',
  @body= @b
  </code></pre>
  
  <p>Package throws error : </p>
  
  <p>"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.</p>