Hi Phill

This the code which begins the loop and searches for the files in folder(basically step 4 from the link you posted.)My files are located in

c:\dtsload and the archile files...

Hi Phill

The error i'm getting is as follows

"You had a bad directory or two please consult:Source File directory not found archive file directory not found."

What i did was just copy...

Hi Phill

Thanks for the article. I'm finding it very helpful.But i'm facing difficulty from step 4 to step 5 as i'm using excel files i'm not able to set the...

Thanks for the help, was able to solve my problem.

Hi

Thanks for the reply. i tried executing the query, but i got no result:

SELECT No, Fname, Lname,Age FROM Tempname WHERE NOT EXISTS

(SELECT NULL FROM Tempname t JOIN Mastername...