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.

 

Thank you so much