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.
| Author |
Topic |
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
 Posted - 2009-10-20 : 10:38:50
|
I have a data flow task with two OLE DB sources (both of them execute a stored procedure), followed by a Merge Join task which joins (inner join) the outputs based on a key and writes to a flat file.I'm receiving the following error whiel executing the packageError: 2009-10-19 20:03:20.26 Code: 0xC0202009 Source: Extract First Express records OLE DB Source for Gross Prem [128] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x00040EDA Description: "Warning: Null value is eliminated by an aggregate or other SET operation.".End Error Not sure why, I have executed both the stored procs separately, and joined them in T-Sql, there are no NULLS or any other errors. Not sure why I'm receiving this error. Any clues? |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-20 : 13:03:38
|
| Check for any difference in the ANSI SET options in the two connections. |
 |
|
|
8022421
Starting Member
45 Posts |
Posted - 2009-10-21 : 02:20:04
|
| Vijay, Dhana here.Try setting the ISNULL function to the selected columns and execute the package again. |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-10-21 : 09:17:27
|
| Dhana...its the First Express SQL...it already contains the ISNULL function...I'm not sure why its failing only in one environment when there are NULLS everywhere.When I run from SSMS, there is no error.Anyway, as a workaround , I had set the ANSI_WARNINGS off within the Stored procedure. It ran successfully. |
|
|
|
|
|
|
Error while using a Merge Join