Home Forums Data Warehousing Integration Services 2 sql tables with 1000 rows each RE: 2 sql tables with 1000 rows each

  • October 18, 2018 at 4:52 am

    #2010204

    HappyGeek - Thursday, October 18, 2018 12:39 AM

    drew.allen - Wednesday, October 17, 2018 2:19 PM

    mtz676 - Wednesday, October 17, 2018 11:43 AM

    no..the source table is in domain A and the destination table is in Domain B
    So a  row gets added to table A, it should be immediately added to TableB in domain B.
    Can this be achieved in SSIS

    Replication.

    Drew

    +1

    Yes, replication is the recommended way to do it.
    An alternative (if you can create a linked server to connect to both) is to write a stored procedure that updates TableB from a query on TableA, then create a scheduled job and set it to run every 5 minutes or so.