I work out my error:

'SELECT ID, filed2 FROM Mydb.dbo.Mytbl WHERE ID =' + @TblID

Thanks again,

That's am exactly looking for

Thanks Lowell

Your code worked for me. Next step is I have to workout how to pickup one file at a time from the directory.

It is great if you...

It works when you hard code file name. I don't know how to do this in Dynamic sql I will investigate. Thanks for the response.