what is SSIS integrating with .Net? what can SSIS does other than ETL?

ssis is primariy Integration platform for different tyes of datasource starting from text file to excel to sql server , oracle , web services etc etc. What do you want to achieve . if let us know the objective we might be able to point you towards the right (best) tools that you can use from the microsoft techs available.

Thanks Ashwani. It was for job application. They mentioned the requirements as 'SSIS and .Net Integration', which i couldnt understand, as i thoght SSIS is for ETL.

Mohamed Rafi wrote: what is SSIS integrating with .Net? what can SSIS does other than ETL? these questions seem very broad for an interview. anyway, ssis packages can be executed from any .net appication, whether it be windows forms, asp.net, windows services, console apps, etc. also, .net classes can be implementedwithin ssis scripts, custom tasks, and custom components. if you look at the control flow tasks, you'll see many tasks that aren't specific to ETL. ssis provides an easy way to process data using very little custom code in most cases. as a matter of fact, it's possible to create a very robust data processing solution without any code at all. for example, it might be possible to loop through a folder of excel files and load them into sql server tables without writing a single line of code. you might be asking: "how this is possible?" the short answer is that it's because ssis is a very powerful tool in certain data processing scenarios. hth

Hello Mohamed - Maybe they need systems integration, and i don't recommend using SSIS in integration systems, it will be more pwerfull using Biztalk in Systems Integrations, and SSIS as you mentioned in ETL. Best Regards

raf Thanks for sharing.