SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations
SQL Shack
Posted on October 4, 2019
In this article, I will first give an overview of SSIS data types and data types conversion methods and then I will illustrate the difference between changing the columns data types from the Source Advanced editor and using Data Conversion Transformation.
SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
SQL Shack
Posted on October 4, 2019
In this article, I will first give an overview of the OLE DB, ODBC, and ADO.NET SSIS connection managers. Then I will try to illustrate the difference between them when trying to connect to SQL Server.
SSIS Derived Columns with Multiple Expressions vs Multiple Transformations
SQL Shack
Posted on September 25, 2019
In this article, we will first give an overview on SSIS derived column transformation, then we will run an experiment to check if there is any difference between adding multiple expressions within one derived column transformation and adding a derived column transformation for each expression.
Execute SQL Task in SSIS: Output Parameters vs Result Sets
SQL Shack
Posted on September 17, 2019
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
SQL Shack
Posted on September 9, 2019
In this article, I will give an overview of Execute SQL Task in SSIS and I will try to illustrate some of the differences between writing an expression to evaluate SqlStatementSource property or writing this expression within a variable and change the Execute SQL Task Source Type to variable.
SSIS OLE DB Destination vs SQL Server Destination
SQL Shack
Posted on August 30, 2019
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.
SSIS Expression Tasks vs Evaluating variables as expressions
SQL Shack
Posted on August 27, 2019
In this article, I will first give an introduction about SSIS expressions, then I will describe briefly the Expression Task and how to Evaluate a variable as expression. Then I will do a comparison between these two features to illustrate the similarities and differences between them.
SSIS OLE DB Source: SQL Command vs Table or View
SQL Shack
Posted on August 22, 2019
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
Stack Overflow
Posted on August 22, 2019
Handling NUL (\x00) value in flat files using SQL Server Integration Services.
An efficient approach to process a SSAS multidimensional OLAP cube
SQL Shack
Posted on August 15, 2019
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"
Stack Overflow
Posted on August 14, 2019
Using NumberFormat property while manipulating Microsoft Excel worksheets using SSIS.
C# - Extract objects from SQL Command
Data Developers
Posted on July 29, 2019
How can I extract all objects mentioned in a SQL Command using C#?
Do you really need to implement Big Data technologies in your ecosystem?
Towards Data Science
Posted on June 16, 2019
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]
Fast load error output doesn't redirect entire batch
Stack Overflow
Posted on June 14, 2019
Explaining the validation types performed when using OLE DB destination component in SSIS
Report dates not working correctly if date format is not mm/dd/yyyy
Stack Overflow
Posted on April 25, 2019
Trying to fix out the date time format issue in SQL Server Reporting Services.
Retrieve multidimensional database objects directories
Stack Overflow
Posted on April 24, 2019
Explaining the contents hierarchy of the SSAS multidimensional cube data directory.
SSIS Script Task error: Exception has been thrown by the target of an invocation
Data Developers
Posted on April 16, 2019
Hanlding SSIS script task error: “Exception has been thrown by the target of an invocation”
How to load mixed record type fixed width file with two headers into two separate files?
Stack Overflow
Posted on April 16, 2019
A step-by-step guide to split a mixed record type fixed width file having two headers into two separate flat files.
Announcing SchemaMapper a C# data integration class library
Tech Blog
Posted on March 6, 2019
SchemaMapper is a C# data integration class library that facilitates data import process from external sources having different schema definitions.
How to Map Input and Output Columns dynamically in SSIS?
Stack Overflow
Posted on February 20, 2019
Some ideas for to develop a dynamic approach fr mapping input and output columns automatically in SSIS data import operations.
How can I fix the number of groups in each page of SSRS
Stack Overflow
Posted on February 10, 2019
Dividing reports into multiple groups using SQL Server reporting services.
Date calculation with parameter in SSIS is not giving the correct result
Stack Overflow
Posted on January 21, 2019
Explaining the cause of the difference between data values generated in SQL Server and the SSIS OE DB Source SQL command.
Ad-Hoc networks QoS and Security overview
Tech Blog
Posted on December 17, 2018
Ad-hoc networks Quality of Service parameters
RaDEn: A Scalable and Efficient Radiation Data Engineering
BDCSIntell'2018
Posted on December 13, 2018
Detecting and monitoring radiation level is one of the critical duties for governments and researchers because of the high threats it oppose to humans. It was challenging in the past century to have a centralized radiation monitoring system until the rise of IoT (Internet of Things). Radiation level is measured...
[Read More]
An Introduction to Data quality
Towards Data Science
Posted on December 9, 2018
There are many definitions of data quality, in general, data quality is the assessment of how much the data is usable and fits its serving context.
