@Chamu, to get the data you have to connect to the data source.
In the Control flow task you can find many tasks that does this job like DataFlow , Execute SQL Task, Script task, XML Task, Web Service Task etc. However, if you are using DataFlow Task, then inside the Data Flow, you can find many data sources like Excel Source, Ado.net Source, Flat file Source, OLE dB source etc. Depending on your requirement, you need to choose the component.
Below are few of my articles, that talks about the same
An indespensible SSIS transformation component - Script Component (
http://web3.codeproject.com/Articles/193855/An-indespensible-SSIS-transformation-component-Scr )
Example 1 of this article uses Dataflow Task, Flat file Source, Script component.
Example 2 of this article uses Execute SQL task, Dataflow Task, Foreach Loop Container, Bulk Insert Task.
Consuming a Web Service created through Sql Server HTTP Endpoints via Web Service task in SSIS (
http://www.codeproject.com/Articles/195508/Consuming-a-Web-Service-created-through-Sql-Server?msg=3897857#xx3897857xx )
This article uses Web Service Task.
In our DNF, Mr. Karthikeyan Anbarasan has written a great series of SSIS articles. The links are as under
http://www.dotnetfunda.com/articles/yarticles.aspx?s=40&p=3&uid=8156 http://www.dotnetfunda.com/articles/yarticles.aspx?s=20&p=2&uid=8156 http://www.dotnetfunda.com/articles/yarticles.aspx?uid=8156 This spans for 40 articles and will be of utmost help for the beginners.
Hope that clarifies your doubt.
Let us know in case you need more help.
--
Thanks & Regards,
RNA Team
Chamu, if this helps please login to Mark As Answer. | Alert Moderator