Error : The result binding name must be set to zero for full result set and XML results

ssis ssis-2008
WhoamI picture WhoamI · Oct 2, 2013 · Viewed 22.4k times · Source

I have only a single row that is being returned from a sql query(count(*)), but upon execution of the package, it shows me the above error and package is failing.

I have the result type to "single row", and have mapped the output of the query(select count(*) as 'result' from abc.tbl_nm) to a variable of type Int32.

Answer

Inus C picture Inus C · Oct 2, 2013

When mapping your 'Result Set', set your 'Result Name' to '0' and 'Variable Name' to the variable you are using.

Related questions

SSIS Error code: 0x80040E37

There is a dataflow task,which consists of excel source and sql destination.When executing dataflow task alone it is runing good.If i execute this dataflow taks inside a a for each loop ,it gives below error [Excel Source [17]] …

Read More
SSIS 2008 R2 - How to dynamically change connections during runtime

I am using SQL Server SSIS 2008 R2. I want to dynamically change a connection manager for OLEDB during runtime to point at a database determined during the running of the package. This means that I cannot use configuration files. How …

Read More
How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More