SQL Server Integration Services (SSIS) DevOps Tools released
(11 May 2020)

Other recent news...

Microsoft highlights .NET 8 Hardware Intrinsics features
Additional hardware functionality via APIs so the bespoke web apps we develop can take advantage of users' underlying hardware, e.g. WebAssembly support so that core algorithms can...
11 December 2023
Google launches Gemini AI model
Gemini was designed for flexibility, so it can run on everything from data centres to mobile devices. It's been optimized for three different sizes: Ultra, Pro and Nano (for on-dev...
6 December 2023
Apple launches release candidate versions of iOS 17.2 & iPadOS 17.2
Developing and testing our bespoke Apple iOS apps on beta versions of iOS 17.2 & iPadOS 17.2 allows our app developers to confirm that the apps we develop will work as expected...
5 December 2023
SQL Server Integration Services (SSIS) DevOps Tools released
This product enables our app developers / app engineers to build continuous integration & continuous delivery (CI/CD) solutions for SQL Server Integration Services (SSIS) projects in Azure DevOps. It contains three tasks:
  • SSIS Build Task: supports building single or multiple dtproj files in project deployment model or package deployment model.
  • SSIS Deploy Task: supports deploying single or multiple ispac files to on-premise SSIS catalog and Azure-SSIS IR, or SSISDeploymentManifest files and their associated files to on-premise or Azure file share.
  • SSIS Catalog Configuration Task: supports configuring folder/project/environment of SSIS catalog with a configuration file in JSON format.
SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.

Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

MicrosoftSQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

SSIS includes graphical tools and wizards for:
  • building and debugging packages
  • tasks for performing workflow functions such as FTP operations, executing SQL statements, and sending e-mail messages
  • data sources and destinations for extracting and loading data
  • transformations for cleaning, aggregating, merging, and copying data
  • a management database, SSISDB, for administering package execution and storage
  • application programming interfaces (APIs) for programming the Integration Services object model

The SSIS Import/Export Wizard lets the user create packages that move data from a single data source to a destination with no transformations. The Wizard can quickly move data from a variety of source types to a variety of destination types, including text files and other SQL Server instances.

Developers tasked with creating or maintaining SSIS packages use a visual development tool based on Microsoft Visual Studio called "SQL Server Data Tools - Business Intelligence". It allows users to edit SSIS packages using a drag-and-drop user interface. A scripting environment for writing programming code is also available in the tool.

more news...