As Phil says I will have to try for a SSIS and Parallelism Approach and do some testing on how this works.

Thank You All for sharing your thoughts.

As i said the project is interesting.What makes it interesting is if you have 9 different companies who want to share there products and...

They are not searching the Database from the UI.The search is on the files.

The DB comes info Picture only till creating the files and maintaining the log of ETL.

Rest is all done using application..which i cant talk about.This is an interesting project.If you...

Hey Phil,

Thanks for the reply.

Our project involves storing the every detail of a product(example).When the users search for the product from the UI, they get this file which has all...