I am looking at developing a Migration ASP.NET application that will accept Database Cardentials for source and destination. Later Runs through some UI so that the user can make changes as to whats needed from the source and whats not, this i log in to tables I call as my custom config tables. I look at the custom config tables and generate an SSIS package dynamically. My question is when i want to execute this SSIS package from .Net code(say a C# component). Do i need Business Intelligence to be installed? Ideally i want to do execution where there is no requirement that BI has to be installed. Is this possible?
Thanks in Advance