Calling WS from SSIS package RRS feed

  • Question

  • Hi there, does anyone has experience calling Web Services from a .dtsx package?


    Instead of using a SQL link server between two datacenters (States and another one in EMEA), I've requested a WS. Idea here is having to a local copy of the required tables in the same physical location So at the end of the day, I'll avoid to use a link server for JOIN stuff.

    Does it make sense for you?

    Thanks for sharing inputs or links related to,

    Wednesday, January 18, 2017 11:11 AM