Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sub Query Parameter in SQL Server DTF Source Expand / Collapse
Author
Message
Posted Thursday, February 19, 2009 12:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 14, 2011 3:00 PM
Points: 2, Visits: 79
I have a specific requirement for which I am querying about 9 tables to fetch the data.

In order to get the accurate data, I have to use a sub query, where I have to pass a parameter which I am getting into the Data Flow Task from a For Each Loop. The SQL Command is recognizing the parameters. It is not letting me even to click on the parameters button.

I am trying this SQL in the SQL COMMAND option in the Data Flow Task - OLE DB Source in SQL Server 2005.

CAN ANYONE SAVE MY DAY and MY JOB, please.....

Post #660696
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse