CODEWITHSUNDEEP
ssismicrosoft-teams
Sam Alex
Sam Alex

Reputation: 119

A way to send a Microsoft Teams chat message from SSIS

Is it possible to send an MS Teams chat message to one or more people or even to a Team Post from SSIS?

We have some processes that send notices via Email, but anymore email is just too busy and it would be nice to have a central location in Teams to have messages when certain items complete or fail via SSIS.

Upvotes: 1

Views: 2534

Answers (2)

Bhupendra kumar
Bhupendra kumar

Reputation: 5

Take help from following Link: Following link help to send text message via sql server Text message via SQL Server

Upvotes: -1

Hilton Giesenow
Hilton Giesenow

Reputation: 10804

The are a few possible options for this. If you're sending email already, the most simple might be to just use the Team (i.e. Channel's) email address. To access this, go to the "..." menu next to the channel name, and select "get email address", as shown below.

enter image description here

A popup will appear showing the channel's email address.

enter image description here

Here's a video showing this.

Another option is to set up an "incoming webhook". I've not done this in SSIS, but I think this would involve using a Script Task to call the endpoint that gets created.

Upvotes: 4

Related Questions