none
Use RestApi in SSIS package to consume and send data RRS feed

  • Question

  • Hi,

    Is that possible to use RestApi in SSIS package to send \ post data and get data . Please suggest if its possible. Also would like to understand the implications of doing this in SSIS package.

    Thanks.

    Wednesday, April 5, 2017 6:30 AM

All replies

  • Hi there,

    The REST API calls are possible.

    I'd suggest a commercial component if you need to move fast as http://www.cozyroc.com/ssis/rest-connection (I am not affiliated with them). It is just less error prone as some REST API are hard to get working even not in SSIS.

    Otherwise you need to code it up yourself in say a Script Task. The code examples can be found online.

    Security would be a thing to thing about as you would need to open up some ports.


    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Albert_ Zhang Thursday, April 6, 2017 2:13 AM
    Wednesday, April 5, 2017 1:21 PM
    Moderator
  • Hi Sir,

    I agree with ArthurZ. If you want to consume the REST API in SSIS, you could have a look at this article to learn the detailed steps. You could also run the code in Script Task as suggested above.

    Besides, if the REST API returns JSON, you could also have a look at this 3rd component. In the download file, it shows how to register the component into your machine.

    Best Regards,

    Albert Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 6, 2017 2:13 AM
  • Yes, it is possible. Here you have a tutorial to POST data in SSIS:

    https://www.youtube.com/watch?time_continue=3&v=zE6P5n744WU&feature=emb_logo


    MVP MCT MCTS Daniel Calbimonte

    http://elpaladintecnologico.blogspot.com

    Tuesday, December 3, 2019 10:54 PM