且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用SSIS使用用户标识/密码连接到REST API

更新时间:2022-01-24 22:24:16

嗨Abhi425,

Hi Abhi425,

最简单的是使用第三方工具,就像CozyRoc所说的那样(我不隶属于他们)。

The easiest is to use 3rd party tools as those say from CozyRoc ( I am not affiliated with them).

否则是的,你需要成为编码。

Otherwise yes, you need to be coding.

SSIS这也不是一个非常典型的任务,因为它通常位于DMZ的防火墙之后。

It is not also a very typical task for SSIS to do so because typically it is behind firewalls in DMZ.

无论如何,对于点,从这里借一个例子:
https://docs.microsoft.com/en-us/aspnet/web-api/overview/advanced/calling-a-web-api-from-a-net-client

Anyways, to the point, just borrow the example from here: https://docs.microsoft.com/en-us/aspnet/web-api/overview/advanced/calling-a-web-api-from-a-net-client

并加入脚本任务。这就是全部。

And put into a Script Task. This is all.