Audience

Developers in need of a powerful Integration solution

About SSIS

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. Integration Services includes a rich set of built-in tasks and transformations, graphical tools for building packages, and the Integration Services Catalog database, where you store, run, and manage packages. You can use the graphical Integration Services tools to create solutions without writing a single line of code. You can also program the extensive Integration Services object model to create packages programmatically and code custom tasks.

Other Popular Alternatives & Related Software
Informatica PowerCenter
Informatica PowerCenter
Embrace agility with the market-leading scalable, high-performance enterprise data integration platform. Support the entire data integration lifecycle, from jumpstarting the first project to ensuring successful mission-critical enterprise deployments. PowerCenter, the metadata-driven data integration platform, jumpstarts and accelerates data integration projects in order to deliver data to the business more quickly than manual hand coding. Developers and analysts collaborate, rapidly prototype, iterate, analyze, validate, and deploy projects in days instead of months. PowerCenter serves as the foundation for your data integration investments. Use machine learning to efficiently monitor and manage your PowerCenter deployments across domains and locations.
Learn more
Azure Data Factory
Azure Data Factory
Integrate data silos with Azure Data Factory, a service built for all data integration needs and skill levels. Easily construct ETL and ELT processes code-free within the intuitive visual environment, or write your own code. Visually integrate data sources using more than 90+ natively built and maintenance-free connectors at no added cost. Focus on your data—the serverless integration service does the rest. Data Factory provides a data integration and transformation layer that works across your digital transformation initiatives. Data Factory can help independent software vendors (ISVs) enrich their SaaS apps with integrated hybrid data as to deliver data-driven user experiences. Pre-built connectors and integration at scale enable you to focus on your users while Data Factory takes care of the rest.
Learn more
CloverDX
CloverDX
(2 Ratings)
Design, debug, run and troubleshoot data transformations and jobflows in a developer-friendly visual designer. Orchestrate data workloads that require tasks to be carried out in the right sequence, orchestrate multiple systems with the transparency of visual workflows. Deploy data workloads easily into a robust enterprise runtime environment. In cloud or on-premise. Make data available to people, applications and storage under a single unified platform. Manage your data workloads and related processes together in a single platform. No task is too complex. We’ve built CloverDX on years of experience with large enterprise projects. Developer-friendly open architecture and flexibility lets you package and hide the complexity for non-technical users. Manage the entire lifecycle of a data pipeline from design, deployment to evolution and testing. Get things done fast with the help of our in-house customer success teams.
Learn more
Apache Airflow
Apache Airflow
Airflow is a platform created by the community to programmatically author, schedule and monitor workflows. Airflow has a modular architecture and uses a message queue to orchestrate an arbitrary number of workers. Airflow is ready to scale to infinity. Airflow pipelines are defined in Python, allowing for dynamic pipeline generation. This allows for writing code that instantiates pipelines dynamically. Easily define your own operators and extend libraries to fit the level of abstraction that suits your environment. Airflow pipelines are lean and explicit. Parametrization is built into its core using the powerful Jinja templating engine. No more command-line or XML black-magic! Use standard Python features to create your workflows, including date time formats for scheduling and loops to dynamically generate tasks. This allows you to maintain full flexibility when building your workflows.
Learn more

Integrations

See Integrations

Ratings/Reviews

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Company Information

Microsoft
Founded: 1975
United States
learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services

Videos and Screen Captures

SSIS Screenshot 1
SSIS Screenshot 1 SSIS Screenshot 2
Other Useful Business Software
Find Hidden Risks in Windows Task Scheduler Icon
Find Hidden Risks in Windows Task Scheduler

Free diagnostic script reveals configuration issues, error patterns, and security risks. Instant HTML report.

Windows Task Scheduler might be hiding critical failures. Download the free JAMS diagnostic tool to uncover problems before they impact production—get a color-coded risk report with clear remediation steps in minutes.
Download Free Tool

Product Details

Platforms Supported
Cloud
Training
Documentation

SSIS Frequently Asked Questions

Q: What kinds of users and organization types does SSIS work with?
Q: What languages does SSIS support in their product?
Q: What other applications or services does SSIS integrate with?
Q: What type of training does SSIS provide?

SSIS Product Features

Integration

ETL - Extract / Transform / Load
Metadata Management
Dashboard
Web Services
Multiple Data Sources