Ganesh,

I can set up the Global Variable, however I get an error under the Transform Data task when selecting the Parameters option:

Package Error:

Error Source: Microsoft OLE DB Provide for ODBC...

Nice catch, I didn't create the query, but I will get with the Analyst that did to verify with him exactly what he is pulling.