(Annette Allen) SSIS is able to take sorted data from more than one OLE DB data source and merge them into one table which can then be sent to an OLE DB destination. This ‘Merge Join’ transformation works in a similar way to a SQL join by specifying a ‘join key’ relationship. this transformation ca
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help