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
Default Buffer Max Size and Default Buffer Size in SSIS

Is there any relationship between Default Buffer Max rows and Default Buffer Size in SSIS. How to supply values to these property parameters? I mean is there any propossionality in between these ?If I double the buffer size double then …

Read More