Thanks for the reply .

I have tried that one but grop comes by side like

company(Group) sellto ...

I have tried that one..result is same like before

Thank you

i have converted into varchar but it is same as before

That is also not working is coming as 10,56,65.64 etc

Thank you.

It is in money datatype..i will try to convert into varchar..and let u know...

Thank you

Please can any one help me in this??

No am opening as text. Can u gve me sum derived column exp

Ya i have tried that But it is not working..is there any other way to do this??

Its a ragged right file and datatype is currency.

when the value is 13.66 its is taking as it is...

but when it is 0.00 in source it is taking as 0

i...

Thanks ..

what is the value of variable...it should be same as env variable like datasource=cccccc;intialcatalog=xxxxx;..................

Can u tell me indetail about that...

Thank you

Thanks

I understand what ur saying...but What if Environment Variable doesnot exist on the server or system where the packge is running???

Thank You

Thank You for Reply..

What if the default connection string is in the environment variabel.??

i package gonna Fail?? if so tht gonna be a pro...

Can u gve me code like if...

Thanks for the reply...

The Envi variable is having connection string of server and database ..

can You explain me in detail..am not familier with script task...

Thank you

Ya it is running on the local machine

Now manager told me that i have deploy those packages to server , have to create configurations and schdule them.

For dynamically select todays date file am using expression like...