SSIS Script Component Overview

SQL Shack

SSIS Script component is a prominent strength of SQL Server Integration Services since it allows developers to implement any complex logic and utilize libraries from the powerful .NET framework or third-parties. In this article, we will give an overview of SSIS Script component, and illustrate the benefits of using it.... [Read More]

SSIS XML Destination

SQL Shack

Until now, Microsoft has not included the XML Destination component in SQL Server Integration Services (SSIS). Many years ago, this component was requested on the Microsoft connect website, but it was closed as “Won’t fix.” For this reason, many workarounds and third-party components were created. In this article, we’ll talk... [Read More]
Tags: ssis xml

SSIS OLE DB Destination vs SQL Server Destination

SQL Shack

In this article, I will give an overview of SSIS OLE DB Destination and SQL Server Destination and I will try to illustrate some of the difference between both destination components based on my personal experience, SSIS official documentation and some other experts experience in this domain.