cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Integration Services (SSIS)

  • 383 Blog Articles
Options
2,125

Run Any SQL Anywhere in 3 Easy Steps with SSIS in Azure Data Factory

Sandy Winarko on Jun 17 2021 03:53 AM
We’ll show you how to quickly extend ADF capabilities by leveraging SSIS, all without designing/deploying your own packa...
1,422

SSIS DevOps Tools new version tasks in preview

Chunhua on Apr 21 2021 11:31 PM
SSIS DevOps Tools new enhancements: SSIS Build task version 1.* (Preview) Remove the dependency on Visual Studio and SSI...
1,984

Bring SSIS ETL lineage into Azure Purview Data Map

Chunhua on Feb 25 2021 11:52 PM
This blog describes how to bring SSIS ETL lineage into Azure Purview Data Map.
2,688

All-in-One: Assessing, Testing, and Migrating SSIS Packages with Azure-Enabled SQL Server Data Tools

Sandy Winarko on Jan 13 2021 09:58 AM
Learn how to use Azure-enabled SQL Server Data Tools (SSDT) as an all-in-one SQL Server Integration Services (SSIS) migr...
3,508

Blast to The Future: Accelerating Legacy SSIS Migrations into Azure Data Factory

Sandy Winarko on Oct 18 2020 04:51 AM
Learn about enablers/features that can unblock and accelerate legacy SSIS migrations into ADF with no/minimal changes to...
3,164

Standalone SQL Server Integration Services (SSIS) DevOps Tools in preview

Chunhua on Oct 15 2020 08:29 PM
Announcing preview of Standalone SSIS DevOps Tools.
2,742

Load data from Always Encrypted enabled Azure SQL database using SSIS in ADF

Chunhua on Jul 22 2020 08:33 AM
This tutorial walks you through the process on how to load data from Always Encrypted enabled Azure SQL database using S...
18.3K

General availability of Microsoft Connector for Oracle

Chunhua on May 24 2020 05:08 PM
Announcing general availability of Microsoft Connector for Oracle.
3,079

General availability of SQL Server Integration Services (SSIS) DevOps Tools

Chunhua on May 11 2020 11:22 PM
Announcing general availability of SQL Server Integration Services (SSIS) DevOps Tools
3,136

Scripts? We don’t need no scripts! – Express custom setups for SSIS in Azure Data Factory

Sandy Winarko on Dec 31 2019 06:09 PM
Express custom setups are common/popular/selected custom setups that have been deeply integrated into SSIS IR, such that...
5,856

VNet or No VNet: Secure data access from SSIS in Azure Data Factory

Sandy Winarko on Dec 12 2019 01:58 AM
Virtual Network (VNet) injection, Self-Hosted Integration Runtime (SHIR) as a proxy, Azure Active Directory (AAD) authen...
5,420

SQL Server Integration Services (SSIS) DevOps Tools in preview

Chunhua on Dec 05 2019 04:21 PM
Announcing preview of SQL Server Integration Services (SSIS) DevOps Tools.
5,731

Microsoft Connector for Teradata for SQL Server 2019 is released

Chunhua on Nov 25 2019 12:33 AM
Microsoft Connector for Teradata is the replacement of Attunity Teradata Connector starting from SQL Server 2019 and now...
7,025

Best practice recommendation for SSIS package execution retries

xichen on Oct 29 2019 08:40 PM
To ensure the completion of your package execution and avoid its repetitive manual invocations, you can configure it to ...
4,227

Azure Feature Pack 1.14.0 released with Azure Data Lake Storage Gen2 Support

Lingxi on Aug 29 2019 10:23 PM
Azure Feature Pack 1.14.0 is here, which enables you to connect to Azure Data Lake Storage Gen2 (ADLS Gen2).
5,413

Run SSIS Package in Azure via SSDT

Jarod_Zhu on Aug 08 2019 11:31 PM
The feature of Azure-enabled SQL Server Integration Services (SSIS) projects on SQL Server Data Tools (SSDT) allows you ...
4,542

Use SSIS to load data in chunks from SQLServer to Excel

qianwen_shi on Aug 06 2019 02:23 AM
This blog provides a solution to use SSIS to load data in chunks from SQLServer to Excel. The sample package has below s...
33.1K

Microsoft Connector for Oracle is released for SQL Server 2019 Preview

Tim.Chen on May 14 2019 01:19 AM
Microsoft Connector for Oracle is the replacement of Attunity Oracle Connector starting from SQL Server 2019 and now it ...
4,087

Deeper Integration and New Connector for SSIS in ADF

Sandy Winarko on Mar 25 2019 04:11 PM
First published on MSDN on Feb 15, 2019 Expanding our efforts to integrate SQL Server Integration Services (SSIS) deeper...

Latest Comments

glennpok
in General availability of Microsoft Connector for Oracle on Oct 06 2021 01:09 PM
@frugecn, after several tries, our DBA and I were able to make this connector work. We were initially getting errors on the server, even after the connectors were installed on it.What we learned:- I had to install both 4.0 and 5.0 64-bit on my laptop, even though our server only has 5.0- Can't use e...
0 Likes
mrazmrazik
in Microsoft Connector for Teradata for SQL Server 2019 is released on Sep 30 2021 12:46 AM
Hello, I have problem when I select table from Teradata and click Preview or Mapping, error message popup : Error at Data Flow Task [Teradata Destination [341]]: SQLSTATE: 07009, Message: [Teradata][ODBC] (10670) Invalid descriptor index, descriptor record does not exist, or descriptor record was no...
0 Likes
frugecn
in General availability of Microsoft Connector for Oracle on Sep 29 2021 08:55 AM
It has been a really long time, but I think you can get away with just the 64-bit install.
0 Likes
glennpok
in General availability of Microsoft Connector for Oracle on Sep 29 2021 08:52 AM
@frugecn, Thanks for your reply. Very very helpful and I've opened a ticket for our DBAs to install the connectors.Just one more question: Should we install both 32-bit and 64-bit on the SQL Server 2016 Enterprise? Or just the 64-bit. Thanks.
0 Likes
frugecn
in General availability of Microsoft Connector for Oracle on Sep 28 2021 08:27 AM
@glennpok, yes you have to install them on the server itself. That is where it is running from when you deploy to the catalog.
1 Likes