Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

sql server

21 Topics

Running SSIS on Azure VM (IaaS) - Do more with less money
First published on MSDN on Jan 05, 2017 Hi all,In the SQL PASS Summit of 2016, I presented a session about "Running SSIS on Azure VM - Do more with less money" and it was well received based on the session feedback.
SSIS-Team
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
10KViews
0likes
0Comments
Error Column Improvements for SSIS Data Flow (Updated for RC2)
First published on MSDN on Nov 27, 2015 Most of the SSIS data flow components allow customers to log the rows with errors to a dedicated error output, which can help customers to investigate and diagnose the root cause of the error.
SSIS-Team
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
7.4KViews
0likes
1Comment
How to add Reference Data Services in Data Quality Services (DQS)
First published on MSDN on Jul 20, 2011 SQL Server Data Quality Services (DQS) is a knowledge-driven data quality solution.
SSIS-Team
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
4.4KViews
0likes
0Comments
Operationalize your machine learning project using SQL Server 2016 SSIS and R Services
First published on MSDN on Jan 11, 2016 With the release of CTP3 SQL Server 2016 and its native In-database support for the open source R language (SQL Server R Services), users can now call both R and RevoScaleR functions and scripts directly from within a SQL query and benefit from multi-threaded and multi-core in-DB computations.
SSIS-Team
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
4.3KViews
0likes
0Comments
Matching related and duplicate Customer Records using SQL Server Data Quality Services (DQS)
First published on MSDN on Jun 17, 2013 SQL Server Data Quality Services (DQS) enables you to match records using your matching rules defined in DQS Knowledge Base.
Welly Lee
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
3.9KViews
0likes
0Comments
Automating the data matching process in SQL Server Data Quality Services (DQS)
First published on MSDN on Jun 25, 2013 OH22 data has just released a free SSIS transform task for SQL Server Data Quality Services (DQS) matching.
Welly Lee
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
3.4KViews
0likes
0Comments
Doing more with SQL Server Integration Services Feature Pack for Azure
First published on MSDN on Jun 24, 2015 More and more of businesses are either storing or manipulating some, if not all, of their data in the cloud.
SSIS-Team
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
3.2KViews
0likes
0Comments
Data Preparation for Azure Machine Learning using SSIS
First published on MSDN on Jun 24, 2015 Microsoft Azure Machine Learning enables businesses to perform cloud-based predictive analytics to understand what their data means.
SSIS-Team
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
2.7KViews
0likes
0Comments
Cleansing Customer Data Using Data Quality Services (DQS)
First published on MSDN on Jun 14, 2013 SQL Server 2012 Data Quality Services (DQS) enables you to cleanse data using your own Knowledge Base.
Welly Lee
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
2.5KViews
1like
0Comments
Using the SSIS DQS Cleansing Component
First published on MSDN on Jul 18, 2011 As part of our DQS CTP3 offering, we are releasing a new DQS SSIS component.
SSIS-Team
Mar 25, 2019 Place SQL Server Integration Services (SSIS) Blog
1.9KViews
0likes
1Comment