As klininger suggests using expressions is always a good approach to solve problems in SSIS... Is Your SQL less than 4000 char's ..if so you can achieve that using expressions..

you can change the variable properties by clicking on the variable and then go to the properties window editor..change the Propertyvalue to "TRUE"

"\" is treated as an escape character .... You always need to add another "\" to escape the other one...

it should be C:\\Sample

I looked at you r package and you have a Raw Source then OLEDB Command and OLE DB Destination... which yu dont need, If you just want to update your...

its connection to SSIS 08 from SSMS 08.. This is the problem with one of our developers who is unable to connect, others don't have any problem... He has also...

I tried To change the DCOM setting but that dint workout ... any other suggestions

Thanks a lot dude!!!!