how to set and get value of Variable in sql server 2005 Integration Tasks

[gzali]

i am working on Sql Server 2005 BI (Integration Services) can anyone help me how to set and get value of user defiend variables.I want to passed some variables like connection string,login,password and paramerters to Integration Task and i want to used that paramerter value in where clouse of my query......very welcome for quick reply...

Ghazanfar Ali Software Engineer (MSTS,MCPD,MCITP)

[John_Adams]

Hi, Please take a look at the following article: ARTICLE2[^] ARTICLE1[^] Hope this helps :).

Regards, John Adams ComponentOne LLC