Sql Server Integration Services (SSIS) is an ETL tool.
In simple words, what an ETL does is that, it extract the Raw information, process that (which is the Transformation) and then loads the same to the destination. e.g.
Given a flat file(say input.txt) that contains some valid and invalid email address, we need to load the valid emails to another text file (output.txt). For that, the Source will be input.txt. Next we have to extract the source data from input.txt. Then have to filter the valid records i.e. transform. And finally push the same to the destination file which is output.txt.
SSIS has many components broadly classified into Control flows and data flows.
After explaining this basic of SSIS, we have to explain the interviewer, the business purpose for the usage of the SSIS package, which components you have use to design that, how you have tested your package and finally deployment.
Having explained, then you also need to tell him how you are invoking the package (i.e. about the hosting environment).
If you have done any performance optimization, please mention that too.
You can also refer to a couple of my SSIS articles, for a more clear picture
1) An indespensible SSIS transformation component - Script Component [
http://web3.codeproject.com/Articles/193855/An-indespensible-SSIS-transformation-component-Scr ]
2) Working with Pivot and UnPivot Transformation [
http://www.codeproject.com/Articles/193842/Working-with-Pivot-and-UnPivot-Transformation ]
And try to explain the same to yourself by following the approach mentioned above.
Hope that helps.
--
Thanks & Regards,
RNA Team
Chamu, if this helps please login to Mark As Answer. | Alert Moderator