prasanna-750812 (12/5/2010)
The number of sources will not be constant for each run.............so i think we can't use multiple sources or multiple data flow tasks.............
Sounds like a case of needing a For Each loop container around a single Data Flow Task, but I'm starting to side with the others given the circumstances.
Why exactly does the business require SSIS involvement?
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.