sqlserver question
Hello fellow sqlserver admins!
My question for today is: which is the better method for copying a simple table from one database to another on another server — an SSIS package or a stored procedure?
Please discuss the pros and cons.
My first impression is that SSIS is overkill for this task but I’m having a hard time deciding.