|
|
Browse by Tags
All Tags » SQL » raw files » SQL Server Integration Services
-
One of the great selling points of ETL tools such as SSIS is that is is possible to move data from source to destination without ''touching disk'' as they say. By this I mean that data can be extracted from source and inserted into a destination without having to stage it anywhere first. Transformations and aggregations can be applied to the data ...
-
It is a very common scenario to be able to load two tables in the same data-flow that have a foreign key relationship between them. The question of how to do this gets raised very often on the SSIS forum so I figured I'd try and address it here.
Basically, its not possible to do this without using a workaround. There are two possible workarounds ...
|
|
|