• Option 2 is not only easier to implement but also more robust as a solution. Use schema binding on the view to make sure future changes are caught properly. The View fetches committed data on the underlying tables and will give the latest available data at the time the package execute the DFT.

    Check if you would require indexed view and filtering on the underlying data, since this you coul generate a txt file with either a full dump of data or deltas?

    Jayanth Kurup[/url]