且构网

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

从ssis连接到azure服务总线队列

更新时间:2023-02-15 11:45:27

一般有两种解决问题的方法

There are two approaches of solving the problem in general

从技术上讲,您可以在SSIS程序包和azure服务总线队列之间使用单独的基础结构片段,后者可以使用nuget引用Azure SDK并为您放置票证,然后您的SSIS程序包将调用此REST Web api来放置票证内.

you could technically have a separate infrastructure piece between your SSIS package and the azure service bus queue which could reference the Azure SDK using nuget and put tickets for you, your SSIS package would then be calling this REST web api to put the ticket in.

您可以在SSIS包的脚本任务中引用Microsoft.ServiceBus.dll,该脚本任务将构造BrokeredMessage并将其放入队列中.

You could reference the Microsoft.ServiceBus.dll inside a script task in the SSIS package which will construct a BrokeredMessage and put it in the queue.

需要使用gacutil.exe将dll添加到GAC中,脚本任务才能在运行时工作.

The dll needs to be added to the GAC using gacutil.exe for the script task to work at runtime.

您可以创建一个脚本任务,该脚本任务使用azure服务总线REST API调用和放置消息.这里有一个教程: https://msdn.microsoft.com/zh-cn/library/azure/hh416754.aspx ,但是我从来没有碰到过发送实际数据的问题.

You could create a script task which calls and puts message using azure service bus REST API. There is a tutorial available here : https://msdn.microsoft.com/en-us/library/azure/hh416754.aspx but I never happened get beyond the point of sending actual data.