hey,

I have created a Date Dimension in my cube. I am using the same Date table that has been used in the MS AdventureWorks sample project.

I have following dimensions in...

Right now I am able to generate the SQL query dynamically using "SCRIPT TASK". In the Script Task I have written the code to retrieve the projectIDs from SQL Server...

I am joining 3 tables in my actual query. This is a huge dataware house.

Is there any way to retrieve project IDs from SQL Server table and store it...

Thank you very much for the reply.

I am using OLE DB data source. Can you please tell me how to assign the variable in the query. Any link will help...