Hi Anu

Please ignore my previous two posts. I worked out how to do this now. its working in excel and flat file... not sure what i changed from...

Hi Anu

Further to my above post, I made one step progress.. I have now been able to create an excel file and set the expression as before

@[User::file_path] +"filename_"+ (DT_WSTR,...

Hi Anu

I am about to give up on this and forget it... but I want to give it one last try... I am creating the whole new thing again... I...

Hi Anu

Still not working... Am getting an error message again... please find attached

and if i remove the expression from the connection manager it only stores one row of data (the...

Hi Anu - Here is what I have done.. I followed your instructions step by step

Created two variables (ObjRecordset of type Object at package level)

(ObjRecords of type int...

hi john

The link is not working. I keep getting blank page both at work and at home...

thanks

vani

Hi Anu

Can you please send me the package that you have. I will save it on to my local machine and try to see where i am going wrong....

Hi Anu

That works but it saves all data into the same excel file. I tried creating expressions in the connection manager properties but i only get error messages. I...

Hi all

i have worked this out now. thanks for your solutions. i have used the tips given and its working now...

thanks again

Vani

Hi all

Thanks for your help. I am trying to understand and implement it. But this is what I tried and it seems to be ok for now but...