Search:

Indirect :--- If you have multiple flat files different location or different names of file with same structure you can store the all files path in a New file, give newly created file name in the...

using Bad file you can,try

create a router transformation define 3 groups for 3 output, in session properties create a partitions on the router in Round robin base, try it ok
:)

First Dimension tables than fact tables.
why because first your business should existed than transaction
ok. D to F

In Designer, Using SA tab there Import From DB, click the browse button in ODBC window, there select the system dsn,click the ADD button.
select .MDB for Access DB, for excel .xls using this create...