is there any way that can help me in getting data from one source then insert them into two different tables (for example Customer and Order)? I am using OLE DB destination and it is inserting in one table only
Sure. In a Data Flow task have one source task, a conditional split or multicast, and multiple destination task.
Or if you'd prefer multiple data flow tasks with the same source, but different destinations.
Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.
Over the last 2 years, I have been working on SSIS 2008. Really the tough tasks in SSIS are to deploy packages and pass parameters (Values from outside package).
The latter is certainly a headache for developers, particularly for me. We had to ma…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.