CODEWITHSUNDEEP
databasessis
Arjun Singh
Arjun Singh

Reputation: 1

Updating two databases on different server using SSIS

I have a database A and database B(on different servers), both databases contains emp table, I want to update this emp table on both databases using single dtsx file using SSIS. Source: flat file, Destination: emp tble

Upvotes: 0

Views: 186

Answers (1)

billinkc
billinkc

Reputation: 61201

You're looking for the Mulitcast component. It allows for multiple downstream components to access the same data (without physically copying the data around in memory)

Control Flow

           Execute SQL Task (Truncate S1.A.dbo.emp)
                  |
           Execute SQL Task (Truncate S2.B.dbo.emp)
                  |
            Data Flow Task

DataFlow Task

           Flat File Source
                  |
              Multicast
                  |
OLE DB Dest S1.A     OLE DB Dest S2.B

Upvotes: 1

Related Questions