Please Tell me if I am not clear
You are not clear.
What is MNC?
What do you mean by 'real time'?
Visual Studio (in the form of BIDS or SSDT) is the primary development environment for SSIS packages.
I think you may have some more reading and learning to do before you can make best use of these forums, which are intended mainly for people who have questions on specific development areas.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.