Thanks for the quick reply.

I understand the importance of using schema along with object names. How ever, still trying to understand why it was working in Sql 2000 for...

Thanks a lot CozyRoc. I will look into the links that you prodived.

Also, I have tried using the file system Task to delete files. It works fine.

Thanks,

Suresh

Thanks a lot Ramesh..

I have done it using Excel Source and OLEDB Command. I chose OLEDB command since I usually have a less no. of records in my Excel...

Thanks for the reply Ramesh..

As per my understanding, If I use Excel source and OLEDB destination, all rows from Excel will get inserted into my destination table which I should...