Table data Queue processing

Question

User-1363023537 posted

Hi,
 My scenario is like this 
Asp.net application inserts rows in X table at SQL SERVER A. I need to delete top 1000 rows and insert them into remote table Y on SQL SERVER B. 

Can someone tell me how can I use SSIS package here? or is there any other better approach?

Thanks, Satalaj.
 

Answer 1

User-1804440612 posted

You can Use SQL Bulk Copy. For more details visit:

http://www.codeproject.com/KB/database/SqlBulkCopy_in_Asp_Net.aspx

Answer 2

User-1363023537 posted

SQL bulk copy dosen't feet in this scenario. I want to achive it using SSIS package.

-Satalaj 

Answer 3

User78336405 posted

Hi,

Check this:http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm .