SSIS, SQL CLR, PowerShell
On this page:
As a .NET assembly, Rebex Secure Mail can be called from various platforms that support .NET technology.
In the SQL Server Integration Services (SSIS) packages you can use most of the functionality of mail component using the Script task.
For step-by-step instructions see article describing how to call Rebex SFTP methods using an SSIS Script Task. Usage of mail component is almost identical.
Mail classes can be used from Microsoft SQL Server T-SQL code using so-called "SQL CLR procedures". For step-by-step instructions, please see the blog post about registering and using Rebex components from an SQL-CLR procedure.
Using mail classes from a PowerShell script is straightforward. For step-by-step instructions see article about using Rebex SFTP from a PowerShell script. Rebex assemblies can be stored in a file system or in Global Assembly Cache (GAC).