Hello World in Dapper

Hello World in Dapper

When it comes to use an ORM tool for a .NET platform, there are various options. Most of you will think EF as a first option, some of you will think NHibernate as an alternative. Both of them are mature products with a top-notch functionality. But sometimes learning curve of these products can be overwhelmed. In this article I would like to present you an alternative to above-mentioned biggest players on the market. Dapper ORM is the product. It is…

Read More Read More

SSISDB package execution timed out

SSISDB package execution timed out

Today the main actor of this post is this error: Failed to execute IS server package because of error 0x80131904. Server: ASGARD<c/> Package path: \SSISDB\ASGARD\ASGARD Staging\Orchestrator_Transaction.dtsx<c/> Environment reference Id: 20012.  Description: The operation failed because the execution timed out.  Source: .Net SqlClient Data Provider  Started:  05:00:00  Finished: 05:00:11  Elapsed:  10.484 seconds. Disclaimer: Solution provided here is rather a kind of a workaround than a real one. It helps to overcome above-mentioned problem in a quick way, but in a long…

Read More Read More

Simple full load SSIS package in Biml

Simple full load SSIS package in Biml

In this post I will show a simple full load SSIS package and how it can be created in Biml. Introduction I will try to show how to deal with these components of SSIS in Biml: Connections (Connections Managers) Variables Package(s) Tasks Containers Precedence Constraints Data Flow (as a specific type of Task): How to Extract data How to Transform data How to Load data So quite a lot of new stuff to learn. There are, however, several assumptions, which are:…

Read More Read More

Dynamic parameterisation of Azure SSIS Data Flow Components

Dynamic parameterisation of Azure SSIS Data Flow Components

In this article I would like to explain how to dynamically parameterise some of the Azure Data Flow Components settings. Introduction With Azure Feature Pack for SSIS, 4 new Data Flow Components were added: For Blob Azure Blob Source Azure Blob Destination For Data Lake Azure Data Lake Store Source Azure Data Lake Store Destination   Very often there is a need to parameterise some of the settings of these components. One of the most useful parameters can be: For Blob…

Read More Read More