EXEC SQL Task - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

EXEC SQL Task

Author

Topic

SeekingWisdom
Starting Member

24 Posts

Posted - 2007-11-09 : 14:21:08

Hello, I am very, very new to the world of SSIS and from a totally different platform (iSeries), learning, digging and finding golden nuggets as I go.

Two questions please.

Question One:

I am presently encountering the following exception.

SSIS package "DW.CUST_CNCL_ORD.dtsx" starting.
Error: 0xC00291E2 at BP Parter Exec SQL, Execute SQL Task: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".
Task failed: BP Parter Exec SQL
Warning: 0x80019002 at DW CUST_CNCL_ORD: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "DW.CUST_CNCL_ORD.dtsx" finished: Failure.

Try as I do to find information regarding this exception, I am not able to. Can anyone share their wisdom on this topic?

Question two:

Is there a book that you may recommend that will contribute to my learning this new platform and evironment? I presently have the SQL Server 2005 integration services book.

Thank you in advance for any information you may provide.

God Bless.

Thanks,

Carlos.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-09 : 23:45:09

1. What does the package do?

2. Check www.sqlis.com.

SeekingWisdom
Starting Member

24 Posts

Posted - 2007-11-12 : 12:39:42

[quote]Originally posted by rmiao

1. What does the package do?

2. Check www.sqlis.com.

Thank you for your reply. I will try to explain it as best as I can given my limited knowledge of SSIS and what I understand thus far.

I have a scrip task that is building a date. This date is then used in an Execut SQL Task as a parameter as follows:

SELECT BUS_YY_ID AS RBUS_YY_ID,
BUS_PRD_ID AS RBUS_PRD_ID,
BUS_PRD_STRT_DT AS RBUS_PRD_STRT_DT,
BUS_PRD_END_DT AS RBUS_PRD_END_DT
FROM BP.BUS_PRD_DT
WHERE (BUS_YY_ID = ?)

The question mark is named as parameter 0 (zero).

The four columns referred above in the sql as "rbus_yy_id, rbus_prd_id, rbus_prd_strt_dt, rbus_end_dt are defined as paramaters as well with parameter names of 1, 2, 3, and 4 respectively. Each of these are further defined with a direction of "output".

Any information you can share towards overcoming this hurdle would be greatly appreciated.

Thank you and God Bless.

Carlos

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-12 : 22:43:56

Didn't get it.

SeekingWisdom
Starting Member

24 Posts

Posted - 2007-11-13 : 09:15:02

When you say you didn't get it, are you saying you didn't understand what I presented in prior response? Or, where you expecting additional information from me?

your patience and understanding in my questioning is apprecaited.

Thanks..

Hommer
Aged Yak Warrior

808 Posts

Posted - 2007-11-13 : 09:37:56

It looks like you try to get the return values into those four output paramter variables. It is kind of odd, but are you sure they only return one value per column name? Normally, you want to get a set of data to work with.

How did you wire the return values with the output variables?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources