I have looked at everything I can think of and can't figure out which transformation task to use to be able to simply use a sql statement to determine what data to move. Basically I just want to move certain data from each table in production to an archive table in another server. I want to use something simple like "select * from table1 where date > getdate() -90" to determine the source data and just copy all of it into the destination.
What do I use?
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/