No column information was returned by the SQL Command

• Deepz

  SSC Veteran

  Points: 204

  More actions

  October 29, 2014 at 11:14 pm

  #291990

  Hi

  I am working on SSIS Package where I need to Update data if it exists. I am using SSIS 2012 with VS 2010.

  I have put OLEDB Destination and put below SQL.

  Update Table

  Set firstname= ?

  , lastname= ?

  WHERE email= ?

  

  When I click on mapping then I am getting this error "No column information was returned by the SQL Command.".

  Any thoughts?

• Koen Verbeeck

  SSC Guru

  Points: 259125

  More actions

  October 30, 2014 at 1:45 am

  #1755690

  You cannot update a table using the OLE DB Destination.

  You need to use the OLE DB Command for that. However, this component will update the table row by row, so it is extremely slow.

  You better write the rows to a staging table and then use an Execute SQL Task to issue an UPDATE statement.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP