SSIS: OLE DB Source Editor: Show the SQL query from a variable - by Jamie Thomson

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<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 284301 Comments
Status Closed Workarounds
Type Suggestion Repros 1
Opened 6/26/2007 10:56:06 AM
Access Restriction Public


The OLE DB Source Editor allows us to use a SQL query that is stored in a variable by setting Data Access Mode = 'SQL Command from variable'.

The problem with this is that it is not possible to see the SQL query without coming out of the OLE DB Source Editor.
Sign in to post a comment.
Posted by Microsoft on 10/15/2007 at 1:58 PM
Thank you for the question. We have past the date to checkin for CTP5. I think it will be available in CTP6 instead.

Posted by Jamie Thomson on 10/15/2007 at 11:59 AM
Good stuff. Thanks alot. Does next" release" mean the next CTP?
Posted by Microsoft on 10/15/2007 at 10:31 AM
This is to let you know, we have resolved the problem you addressed. It will be available in the next release. Thank you for your support!
Posted by Jamie Thomson on 7/6/2007 at 3:10 PM

Who said the SSIS team don't listen to their customers :)

Thanks Deniz.This is great news!

Posted by Microsoft on 7/6/2007 at 12:19 PM
Thanks to Jamie and others who commented on this. We were actually going through a hard triage meeting looking at hundreds of DCRs and at first rejected this item as we thought it didn't fit into our priorities in Katmai.

We thought about it again, and the good news is that we decided to take this in Katmai. I actually changed the state of this bug to be approved.

Thanks again for being patient and persistent with us.

Deniz Erkan - msft
Posted by Jamie Thomson on 6/29/2007 at 3:21 PM
Why on earth has this been set to "Resolved (Won't Fix)"

Posted by Phil Brammer on 6/26/2007 at 11:23 AM
Yep, a good feature that should be easy to implement and one that adds great value to the GUI.
Posted by Rafael Salas on 6/26/2007 at 11:07 AM
Having that ability would save tons of round trips to and from the variables/expression editor. I'd like to have something like this...