InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:32:21 GMT20http://www.sqlservercentral.com/Forums/Topic1421504-2799-1.aspxDepends on your server hardware, load, network etc.Could be 1 at a time could be 100000000.Tue, 19 Feb 2013 04:56:50 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1421504-2799-1.aspxif many dft is that affect the performance are notTue, 19 Feb 2013 04:55:24 GMTmpradeep23http://www.sqlservercentral.com/Forums/Topic1421504-2799-1.aspxconnection string yes, table name noyou can have as many source and destinations in 1 DFT as you wishTue, 19 Feb 2013 04:21:54 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1421504-2799-1.aspxin SSIS Package can i get data from muitiple table in single data flow task and can we pass connection string and tables name thanksTue, 19 Feb 2013 04:20:59 GMTmpradeep23http://www.sqlservercentral.com/Forums/Topic1421504-2799-1.aspxthen look at replication, logshipping, creating your own ssis packages, merge commands etc etc etcTue, 19 Feb 2013 04:12:56 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1421504-2799-1.aspxcontinous data transfer should move data every 3 min to 1/2 hourTue, 19 Feb 2013 04:11:09 GMTmpradeep23http://www.sqlservercentral.com/Forums/Topic1421504-2799-1.aspx1 time transfer or continuous transfer?1 time, use import export data wizard, SSIS, BCP etccontinuous I would look at replicationTue, 19 Feb 2013 03:30:01 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1421504-2799-1.aspxHi i have a requriement i have 3 sql servers instances in 1st i have data in 3 to 4 tables i need to transfer data from ser01 to ser02 and then ser03 for any updates in ser01 on those tables should update in ser02 and ser03 can any suggest the better way to do this thanks with best regrads pradeepTue, 19 Feb 2013 03:15:28 GMTmpradeep23