In this article, I will describe the difference between using output parameters and result sets within Execute SQL Task in SSIS.
Execute SQL Task in SSIS: SqlStatementSource Expressions vs Variable Source Types
SSIS OLE DB Destination vs SQL Server Destination
SSIS Expression Tasks vs Evaluating variables as expressions
SSIS OLE DB Source: SQL Command vs Table or View
SQL Server Integration Services provides a wide variety of features that helps developers to build a robust Extract, Transform and Load process. After many years contributing to SSIS related tags on Stackoverflow.com, I can say that many developers have some misunderstanding about SSIS features (SSIS OLE DB Source, SSIS Expressions,... [Read More]
SSIS Flat file could not deal with NUL (\x00) value
An efficient approach to process a SSAS multidimensional OLAP cube
While building and deploying an SSAS OLAP cube, there are two processing orders that you can choose from when you create a process operation: Parallel (All Objects will be processed in a single transaction): Used for batch processing, all tasks run in parallel inside one transaction. Sequential (Transaction mode): One... [Read More]
C# Script in SSIS Script Task to convert Excel Column in "Text" Format to "General"
C# - Extract objects from SQL Command
Do you really need to implement Big Data technologies in your ecosystem?
Towards Data Science
From many years, “Big Data” has become widespread and trendy. The Big Data technologies started to fill the gap between the traditional data technologies (RDBMS, File systems … ) and the high evolution of the data and business needs. While implementing these technologies is a must for many large-scale organization... [Read More]