dotConnect Team posts

SSIS MultiCast could be the easiest transformation component. Why?

You simply drag it into the Data Flow. Then, point the source to it and point it to one or more transformation or destination components. That’s it. There’s nothing else to configure. But what is it? And how do you use it? This article will show you how to use it with simple examples.

Throttling and rate limiting restrict API access, but they serve different purposes. While rate limiting can limit API usage to ensure stability, throttling prevents users from accessing your APIs over a certain period.

SSIS DateTime expressions are mostly a part of daily ETL tasks. And the functions that come to mind are DATEPART, DATEADD, and DATEDIFF.

Have you ever wondered why you need to mind your SSIS data types? You DO actually need to mind them, because there are numerous data types amounts which, sometimes, as oil and water, don’t mix together. Proceed into the article to know a little bit more about the SSIS universe!

When we plan to develop any web-based application using the .NET Framework, we need to use ASP.NET for development. But, while we are using ASP.NET for any application development, we can also use ADO.NET within that application. We often misunderstand that ASP.NET and ADO.NET are the same or related. But actually, it is not valid. Both are different in the concept of feature and functionality. But definitely, we can use both of them at a time within an application. So, here, we will mainly discuss the critical difference between ADO.NET and ASP.NET. 

You can’t make an SSIS Derived Column useful without expressions. So, how do you write one? This article will give you tips on using derived column transformation.

This article covers cron jobs and how we can leverage Quartz.Net to schedule cron jobs in ASP.NET 6. It shows how we can store messages in a PostgreSQL database using Devart for PostgreSql, Quartz.Net, and ASP.NET 6.

Devart is glad to announce the release of the new versions of multiple high-performance ADO.NET data providers, LinqConnect, and Entity Developer.

Entity Framework Core from Microsoft is a cross-platform, lightweight, and flexible version of its predecessor, Entity Framework. EF Core is an object-relational mapper (ORM) tool that offers a standardized way of storing and retrieving data to and from diverse data sources.

People are ever more in a hurry. They want their data almost right now. And even more, data is getting bigger and bigger. So, you can’t use good old techniques because they’re “good enough”. It has to be fast. And ETL steps are not an exemption. This is where incremental load comes to play. And if you’re on this page, you probably are looking for incremental load in SSIS.