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.....