thanks that worked perfectly.

ok so what i am doing is :

I have a execute sql task and in expressions i am trying to insert some values to the table so i am using...

^^ but this way i am not able to put it in expression it gives me an error when evaluating.

try this:

http://bi-polar23.blogspot.com/2007/09/loading-multiple-excel-files-with-ssis.html

Anything on this please ^^^

thanks but date time still does not work.

also how would i erase the .csv file in server. i managed to download them then upload them but cant erase...

i have :

pscp...

Hi,

I have tried it but for some reason it doesnt work it says remote to remote not supported

also how would i echo the date and time , i have said...

thanks for the reply everyone... so far i managed to create a batch file that connects to server and downloads the files. now i want to move the file in...

hi,

thanks for your suggestion.

Do you have a sample of the connection in a batch file or something... as i seem to have problem connecting. it says host not found.

thanks