runal_jagtap (3/21/2013)
Jeff, Yup The Srever & the Database would be different...Why it would be overkill :w00t: explain me.. coz i am going to do it.. i dont know how to do it..
If you've already decided to use SSIS, then my suggestion of making a simple job do a simple insert to the archive and a simple delete from the source would probably underwhelm everyone's gumption. Like I said, doing this through SSIS is real overkill.
--Jeff Moden
Change is inevitable... Change for the better is not.