SQL Server Integration Services (SSIS)

380 Blog Articles

Options

893

Sandy Winarko on 01-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...

1,772

Sandy Winarko on 10-18-2020 04:51 AM

Learn about enablers/features that can unblock and accelerate legacy SSIS migrations into ADF with no/minimal changes to...

1,711

Chunhua on 10-15-2020 08:29 PM

Announcing preview of Standalone SSIS DevOps Tools.

3,515

RanYeMSFT on 08-23-2020 08:32 PM

2,054

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...

1,253

Lingxi on 07-20-2020 06:35 PM

13.5K

Chunhua on 05-24-2020 05:08 PM

Announcing general availability of Microsoft Connector for Oracle.

2,510

Chunhua on 05-11-2020 11:22 PM

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

2,706

Chunhua on 04-08-2020 10:17 PM

1,648

Chunhua on 04-07-2020 08:00 PM

1,184

Lingxi on 04-06-2020 11:30 PM

2,565

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...

4,326

bofanMSFT on 12-25-2019 12:42 AM

3,913

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,635

Chunhua on 12-05-2019 04:21 PM

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

3,565

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...

2,130

Chunhua on 11-12-2019 06:17 PM

3,853

bofanMSFT on 11-06-2019 01:31 AM

4,791

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,814

Lingxi on 10-23-2019 11:02 PM

3,485

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).

4,329

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,550

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,883

VincentHe on 06-24-2019 11:43 PM

23.2K

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 ...

60.8K

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

3,589

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,773

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...

5,149

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,702

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...

Latest Comments

in General availability of Microsoft Connector for Oracle on 01-25-2021

SSIS Execute SQL Task cannot be used with Data Flow Task for each row. I am using OLE DB Command Task. But getting this error"Provider does not provide parameter information and SetParameterInfo has not been called". Wondering why such a basic functionality of Upsert or just Update is not covered by...

0 Likes

in General availability of Microsoft Connector for Oracle on 01-24-2021

@ykhabins , how are you using the SSIS Execute SQL Task to connect to Oracle? Are you setting the ODBC connection manager to the SSIS Execute SQL Task and using the DataDirect ODBC driver for Oracle in the connection manager? The DataDirect ODBC driver for Oracle shipped with SSIS is only for intern...

0 Likes

in General availability of Microsoft Connector for Oracle on 01-24-2021

@gsinghpt , are you using the OLE DB Command Task? It is not supported to use Oracle connection manager in OLE DB Command Task. To update the Oracle (not insert), please use SSIS Execute SQL Task. You need to find a ODBC driver for Oracle or OLDB driver for Oracle and setup the corresponding ODBC/Or...

0 Likes

in General availability of Microsoft Connector for Oracle on 01-24-2021

@Chunhua, The existing Oracle Destination functionality is just for INSERT operations.What is missing is that SSIS Execute SQL Task is not supported for Oracle Connector connections. This will allow to execute direct UPDATE, or call Oracle modules or procedures. As of today, such attempt to execute ...

0 Likes

in General availability of Microsoft Connector for Oracle on 01-24-2021

@Chunhua thank you for your response. I didn't find any information on how to update the data from the link you shared. Can you provide an example?

0 Likes