[Execute SQL Task] Error: Executing the query "EXEC UpdateSSISLog ?" failed with the following error: "The batch could not be analyzed because of compile errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection n

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  November 22, 2016 at 2:23 pm

  #337631

  I used the following as an example to return a single result set:

  https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets

  Things were going fine until I get to the section Returning a Single-Row Result Set.

  I appear to have my mappings correct as specified in the article.

  EXEC usp_UpdateSSISLog ? (renamed to SP with a usp_ prefix).

  I'm not sure what I'm missing.

  Does anyone have another article?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  November 22, 2016 at 2:27 pm

  #1914128

  I do not know what I did but it is working now. 😎

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/