This article explains both the SSIS term extraction and term lookup components. Besides, it illustrates the use cases of each one of them.
SSIS Term Extraction vs. Term Lookup
SQL Shack
SSIS Script task vs. Script Component
SQL Shack
This article explains the SSIS Script task and Script component, the scripting tools available in the SQL Server Integration Services (SSIS).
Is it Possible to Load data to MongoDB Using SSIS?
Stack Overflow
Is it Possible to Load data to MongoDB Using SSIS? If yes tools required to achieve? Does MongoDB Support all the SQL Operations?
SSIS XML Source vs. XML task
SQL Shack
This article explains the SSIS XML Source and the SSIS XML task, which are the XML-related components in the SQL Server Integration Services.
Data Access Modes in SSIS OLE DB Destination: SQL Command vs. Table or View
SQL Shack
This article compares the SSIS OLE DB Destination SQL command with the “Table or View” data access mode
SSIS Merge Join vs. Merge Transformation
SQL Shack
SSIS Merge Join and Merge transformations are two similar components used to combine two input data sources into one output. This article explains both transformations and illustrates when and how to use each one of them.
SSIS Pivot transformation vs. Unpivot transformation
SQL Shack
This article explains the SSIS pivot transformation and how it differs from the unpivot transformation.
SSIS, query Oracle table using ID's from SQL Server?
Stack Overflow
How to filter data in Oracle based on a SQL Server query result?
Popular free SQL online compilers
SQL Shack
This article will mention some of the most popular free SQL online compilers that help developers debug and test their SQL code without installing an SQL instance locally or buying one on the cloud.
How to write subqueries in SQL?
SQL Shack
This article briefly explains how to write a subquery in SQL by providing examples.