I am able to read files ,but how i will track that i have read my two files in the folder .

Yes the requirement is that they will be deleted since new subfolders are added daily.

SSIS package

Many thanks Luis

Thanks for your reply ,if there any way we can make tables variables memory only

Thanks for your suggestions guys .My problem is solved .Actually on production there was a memory issue on application side which was causing transaction timeout .

Hi Guys ,

There is one more thing I forget to tell that on development server ,everything is fine .Data is uploaded in almost 3 minutes, but on production it is...

Hi,

There is one clustered index on each table .These clustered indexes are also the identity columns

No Dear ,this is giving null as result

TOP n gives us the first n entries of a column

So why has microsoft has made some opposite of TOP .They should also have made BOTTOM

Its not about physical dear.I want to get the last three logically entered values

No it will not give the last 3 entered rows , if ur rows are not in particular order in table.

Example the table it test

Id name

1 ...

thanks dear , my problem is solved

dear when i am executing your query ,its producing result like

124 124(a)

two times its coming,plus second column is not coming