thanks laurie,

but this one also gives like:

date ...

but for 2011 april first week starts from friday,saturday...

using your query it gives like

date week

2011-04-01...

in the last post itself i given... that values only i have...

thanks all...

my problem is excel sheet is not reading the data of mismatch data type...

my excel data is

name phone

sathiyan 1234

rahul...

Hi friends,

I referred some posts and solved the previous problem....but it is working only without package configuration.

if...

sorry friends i forgot to mention. it is in ssis....

hi koen verbeeck,

that link is good.do u know any other link for ssrs and ssas(cubes).

Thanks and Regards

Sathiyan.R

thanks to all,

i think for script component need to know .net coding.am i right?

hi rhythmk..

thanks for ur reply...

i want to join u in gtalk my id 'sathiyan.raul@gmail.com'

Thanks and Regards

Sathiyan.R