Know the true HISTORY, one that really matters:
May 12, 2010
One Div Zero: A Brief, Incomplete, and Mostly Wrong History of Programming Languages
May 6, 2010
DFT 2 DFT
In SSIS Data Flow Task (DFT) is the most used task as almost all the ETL is done in DFTs. Situation do arise when we need to use data between two or more DFTs. So how can this be achieved? Well there are a number of ways you can save you data in one DFT to so that you access the same data in another DFT. Below are the different ways to store the data in the intermediate process, to be used again in another DFT or even another package.
- Raw File
- Flat File
- SQL Table
- Excel File
- Recorset destination with Script component as the source
For details check this out: DFT 2 DFT
Subscribe to:
Posts (Atom)