Massimiliano Figinimassyfigini.hashnode.dev·Aug 6, 2020Use Stored Procedures with Temporary Tables in SSISPROBLEM: if you try to execute with a SSIS Data Flow a stored procedure containing a temporary table, you receive this error message: Exception from HRESULT: 0xC020204A Error at From SQL Server to Excel [OLE DB Source [91]]: SSIS Error Code DTS_E_OLE...SQL Server Integration Services
Massimiliano Figinimassyfigini.hashnode.dev·Jul 20, 2020Send html emails with SSISGOAL: send an html email using Sql Server Integration Service PROBLEM: the Send Mail Task in SSIS allows only email in text format and not in html format. SOLUTION: use a C# script instead the Send Mail Task to create and send the email. Add a Scrip...107 readsC#
