SSIS OLE DB Source incorrectly returns zero records in combination with parameter and comment - by Valentino Vranken

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 773689 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 12/6/2012 9:12:45 AM
Access Restriction Public


Given the right circumstances, the SSIS OLE DB Source component in the Data Flow will return no records at all, although it should actually return records.

The bug occurs when the OLE DB Source uses at least one parameter and has a comment line right above the WHERE clause.  The comment should be one using a double-dash.  In short, this results in FMTONLY being set to ON while running the query and thus results in zero records.

More details:

I should also mention that this bug no longer occurs in SQL Server 2012.
Sign in to post a comment.
Posted by Microsoft on 6/1/2016 at 7:39 PM
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SSIS. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available.

If the issue is a critical business interruption, please call CSS (Customer Support Services).

Thanks again for reporting the product issue and continued support in improving our product.
Posted by Koen Verbeeck on 12/6/2012 at 1:26 PM
I can reproduce this as well. It's not the most annoying bug, but it can cause you to scratch your hair for a few hours while you're wondering where all your rows went.