Last post Mar 01, 2010 01:37 AM by Song-Tian - MSFT
Feb 25, 2010 01:35 AM|satalaj|LINK
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?
Feb 25, 2010 02:35 AM|shawpnendu|LINK
You can Use SQL Bulk Copy. For more details visit:
Feb 25, 2010 02:42 AM|satalaj|LINK
SQL bulk copy dosen't feet in this scenario. I want to achive it using SSIS package.
Mar 01, 2010 01:37 AM|Song-Tian - MSFT|LINK
Check this:http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm .