I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the linked server, which means I can not access data from other SQL server using Stored Procedure (Am I right ?).
The bottom line I can think so far, create a fake DB under the same server and work on "20%" data then use SSIS transfer the whole fake DB to other server. Please let me know what you think.