Thanks for your reply.

Yes I thought about using job ID. But still there are chances that someone might delete the job and create new one.  I will use job ID as...

Thanks for your reply.  Yes I also thought that this would be the only solution and therefore in my first original post I have a second question which is as...

Do you mean error message for this SQL. Well the only errors reported will be at line 3 (insert...) which would say - the table has identity column...

Error: SQL Server does not exist or access denied

Thanks.  Finally I decided to put messages in windows event log.

I finally used ActiveX script to achieve my goals.

Function Main()

 Dim remoteURL, username, password, transferMode, localDir, remoteDir, remoteFile

 Dim fso, ftpscrfileName, ftpscrfileDir, scriptscr, ftpscrfile

 Dim ReturnCode, Ouput

 Set fso = CreateObject("Scripting.FileSystemObject")

 ftpscrfileDir = "C:\"

 ftpscrfileName =...

Thanks for your answer.  I am building real tables and dropping after every run.  I was just thinking about creating temp tables.

Thanks again for your response.

I have an excel spreadsheet downloaded using http://ftp.  The excel spreadsheet contains hundreds of rows, but I want to extract only certain required rows. I therefore require temp...