SSIS Components

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.

What’s the big deal with SSIS Execute Process Task?

Among the many SSIS components, Data Flow and SQL tasks are enough for simple tasks. Using SSIS to compare two tables is one example. But sometimes, those task components alone are not enough for our requirements. Executing a batch file, a PowerShell script, or an executable file as the next step makes sense. So, why not make use of it in SSIS?

Devart is glad to announce the release of SSIS Data Flow Components 2.0 with support for 27 new data sources. We have supported Snowflake cloud data warehouse and a number of cloud applications, including several new inventory management solutions, like DEAR Inventory or Zoho Inventory, a number of new cloud CRMs, such as Pipedrive and Insightly CRM.

SSIS Data Flow Components now also support new cloud app categories, for example, Ads and Conversion, with such widely used tools as Google Analytics, Google Ads, and Twitter Ads. See the full list of the sources below:

Devart is glad to announce support for the latest PostgreSQL version – PostgreSQL 13 – in the newly released dotConnect for PostgreSQL 7.19 and SSIS Data Flow Components 1.15 as well as in LinqConnect, and Entity Developer products.

Devart is glad to announce support of SSH connections in the Direct mode in dotConnect for Oracle 9.12 and SSIS Data Flow Components 1.14. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSH protocol in the Direct connection mode.

Devart is glad to announce the release of SSIS Data Flow Components 1.13 with support of OAuth 2.0 authentication for Dynamics CRM and a number of improvements for other cloud sources and databases.

Devart is glad to announce support for the latest SQL Server Integration Services – SSIS 2019 – in its products that support SSIS – Devart SSIS Data Flow Components and dotConnect providers for databases.

Devart is glad to announce support of OAuth 2.0 authentication in dotConnect for QuickBooks 1.10 and SSIS Data Flow Components 1.12. We have made certain improvements for connecting to QuickBooks, described below.

Devart is glad to announce support for the latest PostgreSQL version – PostgreSQL 12 – in the newly released SSIS Data Flow Components 1.11.
(more…)

We are pleased to announce support of BigCommerce API v3 in dotConnect for BigCommerce 1.9 and SSIS Data Flow Components for BigCommerce.
(more…)