how to get the data in real time ? ssis developers [Resolved]

Posted by Chamu under Sql Server on 8/7/2016 | Points: 10 | Views : 302 | Status : [Member] | Replies : 2
how to get the data in real time ? ssis developers




Responses

Posted by: Rajnilari2015 on: 8/7/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
@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

Posted by: Chamu on: 8/8/2016 [Member] Starter | Points: 25

Up
0
Down
thank you so much sir . vit is very helpful to me

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response