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: 
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)
Home
Options
886

General availability of Microsoft Connector for Oracle

Chunhua on 05-24-2020 05:08 PM
Announcing general availability of Microsoft Connector for Oracle.
1,104

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

Chunhua on 05-11-2020 11:22 PM
Announcing general availability of SQL Server Integration Services (SSIS) DevOps Tools
1,731

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

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...
1,816

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

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...
3,556

SQL Server Integration Services (SSIS) DevOps Tools in preview

Chunhua on 12-05-2019 04:21 PM
Announcing preview of SQL Server Integration Services (SSIS) DevOps Tools.
1,643

Microsoft Connector for Teradata for SQL Server 2019 is released for preview

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

Best practice recommendation for SSIS package execution retries

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 ...
2,534

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

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

Run SSIS Package in Azure via SSDT

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 ...
2,502

Use SSIS to load data in chunks from SQLServer to Excel

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

Microsoft Connector for Oracle is released for SQL Server 2019 Preview

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 ...
3,063

Deeper Integration and New Connector for SSIS in ADF

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

New Azure Feature Pack Release with Data Lake Analytics Task & Enhanced SQL DW Upload Task

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

Modernize and Extend Your ETL/ELT Workflows with SSIS Activities in ADF Pipelines

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...
1,954

Enterprise Edition, Custom Setup, and 3rd Party Extensibility for SSIS in ADF

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...
1,787

Lift & Shift your SSIS Package Execution to the Cloud on Azure today!

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

New Azure Feature Pack Release Strengthening ADLS Connectivity

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...
3,726

SSIS designer is now available for Visual Studio 2017 !

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

SSIS on Linux supports RedHat in SQL Server 2017 RC1

SSIS-Team on 03-25-2019 04:08 PM
First published on MSDN on Jul 19, 2017 Dear all,I am very pleased to announce that SSIS on Linux supports RedHat in SQL...
2,543

How to design your SSIS package with ODBC connection on Windows and run it on Linux?

SSIS-Team on 03-25-2019 04:08 PM
First published on MSDN on Jul 13, 2017 Before we start, let us consider below questions: As SSDT is not supported on Li...
817

ODBC is supported in SSIS on Linux (SQL Server 2017 CTP 2.1 refresh)

SSIS-Team on 03-25-2019 04:07 PM
First published on MSDN on Jun 16, 2017 Dear all,We just announced SSIS on Linux CTP2.
Latest Comments
Johannes_Vink
in General availability of Microsoft Connector for Oracle on 05-24-2020
What about Azure SQL DB? Or Azure Synapse (formerly known as...)?
0 Likes
Junxiao_Ma
in Microsoft Connector for Oracle is released for SQL Server 2019 Preview on 05-19-2020
Hi @ykhabins , I suppose that your purpose of executing package in SSDT is to help design the package. So I think you can set the protection level to other options in designing phase. After finishing package design, you can set the protection level to DontSaveSensitive and run the packages elsewhere...
0 Likes
ykhabins
in Microsoft Connector for Oracle is released for SQL Server 2019 Preview on 05-19-2020
Hi @Junxiao_Ma, We don't want to save the password in the package, that's why we set package ProtectionLevel as DontSaveSensitive. We also tried to use Oracle connection parameterization (right mouse click, select "Parameterize..." option), and set both UserName and Password through that. Unfortunat...
0 Likes
Junxiao_Ma
in Microsoft Connector for Oracle is released for SQL Server 2019 Preview on 05-19-2020
@ykhabins please set the package protection level to options other than DontSaveSensitive. DontSaveSensitive option will not save password in the package which causes connection error during package execution in SSDT.
0 Likes
ykhabins
in Microsoft Connector for Oracle is released for SQL Server 2019 Preview on 05-19-2020
My environment:- VS2019, v.16.4.6- SSIS Integration Services Projects for VS2019, 15.0.2000.94- Microsoft Connector for Oracle, v.2019.150.2000.110 (both editions 32-bit and 64-bit)- MS SQL Server is NOT installed on my machine- Oracle Client is NOT installed on my machine SSIS project settings:- SS...
0 Likes