Should I use SSIS or stored procs to copy data from a number of database tables on one server to database tables on a different server?
Each table's structure is identical to the destination server except for an identifier added to the destination table. There is no real data transformation. The process would get called from a user application.
My thoughts on using SSIS is that each copy process can run simultaneously. Can I do this with stored procs?