Thank you much for such a wonderfull comparision between SQL and MDX..

http://www.aboutsql.in

http://letslearnssis.blogspot.com[/url]

This gona be fun learning.... i will keep looking for this series.. Thanks

you need to add two data flow task to perform this operatoin sequentially.

http://letslearnssis.blogspot.com/

The above trick works well if all files have same set of columns, if not.. you need to do some programming 🙂

http://letslearnssis.blogspot.com/

Yes books from WROX publications are good...

http://letslearnssis.blogspot.com/

good article ...

http://letslearnssis.blogspot.com/

Try Insert Triggers.......Whenever any data is inserted into any of you A,B,C.... tables....Use triggers to do the respective action tat you wanna perform...........

Regards

KB