Sub Query Parameter in SQL Server DTF Source

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Peter He » Sub Query Parameter in SQL Server DTF Source

Sub Query Parameter in SQL Server DTF Source

Rate Topic

Display Mode

Topic Options

Author

Message

raajakumari-939930

Posted Thursday, February 19, 2009 12:15 PM

Forum 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 »

Permissions