Thank u guys for the reply.
Thanks Thom for providing the DDL's
Sorry for not providing any DDL's, As i am working in client VM and there is no internet...

Any help or guidance

Thanks for the response...let me search with the partition sliding

John Mitchell-245523 (6/27/2016)

---

Thanks for the link, but if you don't make it clickable, people aren't going to bother reading it. Anyway, why not create 100 staging tables - one...

John Mitchell-245523 (6/27/2016)

---

If there is no linked server, how are you doing the transfer? Why does this need to be dynamic - does the structure of the source table...

Thanks for the reply.

i am started creating package for this archival process, but it getting

error variable "USER:Tablename" does not contain a valid data object ssis

Following steps i had done...

The DB's are not in same server they are in different server and there is no linked server.

If i use this DELETE with OUTPUT clause it will not work even...

Thanks Eric for the suggestion...it is better than INSERT INTO option. To implement this shall i go with 2nd method where i am using configuration table to store the...

Thank you guys

No i am not using dynamic SQL, just passing it to storeprocedure as a parameter which is used in 'IN' operator.

one doubt does REPLACE has any performance impact.

Thanks

thanks Alan for giving some idea. Here what i had tried till now, it is just in initial stage

--file path location input param

DECLARE @Filepath varchar(max) = 'C:\Files'

--load the file in...

sorry for the bad requirement given here is a detailed one and also the solution. please provide input if there is any better solution.

DECLARE @Temp table(ID varchar(100), code varchar(100))

INSERT INTO...

Thank you guys for your valuable inputs. I checked the execution plan for the UNION and the CROSS APPLY query, i am surprised that the UNION query is still faster...

Thanks chris, Luis for the solution.

This is just the scenario i created, In production there is no temporary table #Test only physical table which consists of 2 million data. This...

Thank you very much for your response, i will test n reply back after weekends 🙂