Sql Server Integration Services (SSIS) is an ETL tool.
In simple words, what an ETL does is that, it extract the Raw information(E
xtract), process that (which is the T
ransformation) and then loads the same to the destination(L
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.
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) A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation [ http://www.codeproject.com/Articles/188075/A-Palindrome-Program-in-SSIS-using-Copy-Column-Der
Kindly let us know if that helpsChamu, if this helps please login to Mark As Answer. | Alert Moderator