SQL Server Integration Services (SSIS)

377Blogs

Options

1,695

RanYeMSFT on 08-23-2020 08:32 PM

1,439

Chunhua on 07-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...

925

Lingxi on 07-20-2020 06:35 PM

11.5K

Chunhua on 05-24-2020 05:08 PM

Announcing general availability of Microsoft Connector for Oracle.

2,008

Chunhua on 05-11-2020 11:22 PM

Announcing general availability of SQL Server Integration Services (SSIS) DevOps Tools

1,963

Chunhua on 04-08-2020 10:17 PM

1,235

Chunhua on 04-07-2020 08:00 PM

949

Lingxi on 04-06-2020 11:30 PM

2,219

Sandy Winarko on 12-31-2019 06:09 PM

Express custom setups are common/popular/selected custom setups that have been deeply integrated into SSIS IR, such that...

3,776

bofanMSFT on 12-25-2019 12:42 AM

2,807

Sandy Winarko on 12-12-2019 01:58 AM

Virtual Network (VNet) injection, Self-Hosted Integration Runtime (SHIR) as a proxy, Azure Active Directory (AAD) authen...

4,170

Chunhua on 12-05-2019 04:21 PM

Announcing preview of SQL Server Integration Services (SSIS) DevOps Tools.

2,532

Chunhua on 11-25-2019 12:33 AM

Microsoft Connector for Teradata is the replacement of Attunity Teradata Connector starting from SQL Server 2019 and now...

1,796

Chunhua on 11-12-2019 06:17 PM

3,092

bofanMSFT on 11-06-2019 01:31 AM

3,686

xichen on 10-29-2019 08:40 PM

To ensure the completion of your package execution and avoid its repetitive manual invocations, you can configure it to ...

3,225

Lingxi on 10-23-2019 11:02 PM

3,030

Lingxi on 08-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).

3,767

Jarod_Zhu on 08-08-2019 11:31 PM

The feature of Azure-enabled SQL Server Integration Services (SSIS) projects on SQL Server Data Tools (SSDT) allows you ...

3,014

qianwen_shi on 08-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...

2,051

VincentHe on 06-24-2019 11:43 PM

17.3K

Tim.Chen on 05-14-2019 01:19 AM

Microsoft Connector for Oracle is the replacement of Attunity Oracle Connector starting from SQL Server 2019 and now it ...

57.2K

Tim.Chen on 04-22-2019 01:33 AM

3,331

Sandy Winarko on 03-25-2019 04:11 PM

First published on MSDN on Feb 15, 2019 Expanding our efforts to integrate SQL Server Integration Services (SSIS) deeper...

1,616

SSIS-Team on 03-25-2019 04:10 PM

First published on MSDN on Jul 10, 2018 Dear Customers,We are happy to announce that we have released a new version of S...

4,638

Sandy Winarko on 03-25-2019 04:09 PM

First published on MSDN on May 23, 2018 As we continue our march towards General Availability (GA) of SQL Server Integra...

2,314

Sandy Winarko on 03-25-2019 04:08 PM

First published on MSDN on Apr 27, 2018 As we continue our march towards General Availability (GA) of SQL Server Integra...

2,001

SSIS-Team on 03-25-2019 04:08 PM

First published on MSDN on Oct 12, 2017 Hi all,Do you want to simply take your on-premises SSIS packages and run it on a...

1,100

SSIS-Team on 03-25-2019 04:08 PM

First published on MSDN on Aug 29, 2017 Dear SSIS Users,I'm happy to announce that we have released a new version of SSI...

4,292

SSIS-Team on 03-25-2019 04:08 PM

First published on MSDN on Aug 23, 2017 Hi all,I'm pleased to announce that the first preview version of SSIS designer f...

Latest Comments

in Microsoft Connector for Oracle is released for SQL Server 2019 Preview on 09-18-2020

@lupji , we've been using the new Microsoft Oracle connector and SQL 2019 as a target for a while now without connection issues. But we don't use tnsnames.ora, rather we put the service name into the connection string. So the connection string value look similar to: SERVER=ourServerName.oracleoutsou...

0 Likes

in Microsoft Connector for Oracle is released for SQL Server 2019 Preview on 09-18-2020

@lupji We managed to get ours working by using the Oracle installer on the server. Previously we had just copied the instant client files and set up the Environment Variables (TNS_ADMIN) manually. This usually works on other servers for .NET apps etc so we didn't have any reason to believe it wouldn...

0 Likes

in Microsoft Connector for Oracle is released for SQL Server 2019 Preview on 09-18-2020

Forgot to mention we are at version 15.0.4053.23

0 Likes

in Microsoft Connector for Oracle is released for SQL Server 2019 Preview on 09-18-2020

I am having a similar issue. We are trying to upgrade our SQL Server to 2019. Currently we have SQL Server 2017 and use Attunity driver to download Oracle data.In 2019, we are not able to download the data. We are stuck at the connection level with this errorThe AcquireConnection method call to the ...

0 Likes

in Accelerate the opening of SSIS package in SSDT on 09-16-2020

Thank you! Thank you.

1 Likes