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)
Options
1,258

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

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

General availability of Microsoft Connector for Oracle

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

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
2,076

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

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

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

Microsoft Connector for Teradata for SQL Server 2019 is released

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

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

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

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

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

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

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

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

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

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

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

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...
4,139

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

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

Latest Comments

Junxiao_Ma
in General availability of Microsoft Connector for Oracle on 08-11-2020
Hi @lb1l4l1, It's a current limitation that you cannot select view under the "Name of the table or the view:". We have plan to fix it. Currently you can use SQL command or go to Advanced Editor =>Component Properties and set the view name in 'TableName' field directly as the workarounds. For the var...
0 Likes
lb1l4l1
in General availability of Microsoft Connector for Oracle on 08-07-2020
Issue when trying to use a view as sourceViews are not listed under Oracle source "Name of the table or the view:" but the package works fine if you use the SQL command and do a select * from view or when view name is set to property [Oracle Source].[TableName]
0 Likes
Junxiao_Ma
in Microsoft Connector for Teradata for SQL Server 2019 is released on 08-06-2020
Hi, @simee5 It is a limitation now that the error table can only be created in the user database. It does not recognize the [schema].[tablename] format. We will provide a fix for it.
0 Likes
nakamura25
in Microsoft Connector for Teradata for SQL Server 2019 is released on 08-03-2020
I have another problem with this.I have to transfere a lot of data from TERADATA to SQL SERVER 2019 to use columnstore index. My TERADATA server is overload. SQL Server 2019 in Windows Cluster. Microsoft SQL Server 2019 (RTM-CU5) (KB4552255) - 15.0.4043.16 (X64) Enterprise Edition: Core-based Licens...
0 Likes
simee5
in Microsoft Connector for Teradata for SQL Server 2019 is released on 07-28-2020
Hi, I have visual studio 2019, TTU 16.20, and Microsoft Connector 1.0. I was able to use the Microsoft connector to pull data out of the Teradata and write to another database successfully. I can find the TD table I want to write to, in the Teradata Destination. However, I'm having issues now attemp...
0 Likes