SSIS Tip - result binding by name is not supported for this connection type
In SSIS when I tried to bind the ADO.NET Result Set to a User Variable by the 'RecordSet Column Name', I got the error 'result binding by name is not supported for this connection type'. The I found that the 'Result Set - Result Name' should be changed to Index of the Column in the Result Set like 0, 1.
In SSIS when I tried to bind the ADO.NET Result Set to a User Variable by the 'RecordSet Column Name', I got the error 'result binding by name is not supported for this connection type'. The I found that the 'Result Set - Result Name' should be changed to Index of the Column in the Result Set like 0, 1.