"Can anyone give me an idea of
to achieve data extraction mechanism using Sql server Integration"
Can you be a little specific on what you are looking for like:
What are you planning on extracting?
What are your planned Sources and destinations?
What are their formats?
Does it need any transformations involved?