{"id":1403,"date":"2017-01-19T17:46:12","date_gmt":"2017-01-19T12:16:12","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1403"},"modified":"2017-01-19T17:46:12","modified_gmt":"2017-01-19T12:16:12","slug":"execute-sql-task-in-ssis","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1403","title":{"rendered":"Execute SQL Task in SSIS"},"content":{"rendered":"

In this write\u2013up we will demonstrate error and solution caused while using SQL Execute Task component in SSIS. This error occurred when candidate of
\nMSBI training<\/a> was trying to perform \u201cSelect\u201d query through Execute SQL Task.<\/p>\n

Error:<\/b><\/p>\n

The error occurred when trying to perform Execute SQL Task. As the name itself says it is a component using which we can execute any SQL tasks whether they are queries or whether they are stored procedures.<\/p>\n

\"1\"<\/a><\/p>\n

Go to \u201cProgress\u201d tab to see error in more detail.As the error here says that \u201cThe result binding name must be set to zero for full result set and XML results\u201d<\/p>\n

\"2\"<\/a><\/p>\n

Now the error describes itself and there is no further easier way we can describe the error. While configuring the Execute SQL Task component there is an option known as Result Set. Now there are different options which we can select as our Result Set.<\/p>\n

Result Set Contains 4 options:<\/p>\n