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 400 tables. Also we are not allowed to use the linked server, which means I can not access data on other server from 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!
SQL 2000, SQL 2005, SSIS, Stored Procedure
November 12, 2009 9:07 PM
June 13, 2013 4:25 PM