We changed our name from IT Central Station: Here's why
2016-05-11T19:39:00Z

What is your primary use case for SSIS?


How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

ITCS user
Guest
2222 Answers

author avatar
Top 5PopularReal User

Primarily for enterprise DW data movement from and to sources as well as between architectural layers of the EDW.  We also use it for batch operational integration between applications. 

2020-08-04T03:08:02Z
author avatar
Top 5Real User

We have used SSIS in many ways. Primarily, it has been used for building ETLs for populating data warehouse and staging areas. We have developed a number of data marts that were populated. We build data migration packages, which have been reused a number of times with minimal configurations. Additionally, we build complex data integrations solutions and data hand-offs between different applications. We have even used it for creating and parsing SWIFT messages for data integration purposes. We also used it for email triggers.

2020-05-22T08:08:00Z
author avatar
Real User

We use this solution to ingest data to a data lake that is built on SQL Server.

2019-10-31T19:09:00Z
author avatar
Top 20Real User

I'm using the solution primarily for e-memory and e-database calculation, mostly data blending (ETL) and massive table joining, etc. I also use it for data preparation and modeling.

2019-07-31T05:52:00Z
author avatar
Top 20Real User

We primarily use SSIS to collect data from one system and transfer it to another. The Classical ETL processing of data.

2021-11-26T14:25:08Z
author avatar
Top 5Real User

We are using SSIS for all of our relational database management systems (RDBMS) data.

2021-09-01T10:50:13Z
author avatar
Top 20Real User

We are using it in our company and for our clients. I have experience in working with the whole data cycle, which includes data collection, transformation, and visualization. I have worked with the end-to-end process, and I have handled data integration, analysis, and visualization. I specialize in Microsoft tools, and I have used SSIS for data integration and Power BI for data visualization. I have also worked with Tableau for data visualization and Talend for data integration.

2021-05-19T19:43:47Z
author avatar
Real User

We are a software development company and implement solutions like SQL Server SSIS for our clients. We do not use this product ourselves in the company but have experience with it because our client asked for it. Our clients use it to transform data and generate reports. The use cases are generally simple, and not advanced or complex.

2021-02-09T12:29:02Z
author avatar
User

ETL and data warehousing

2020-06-08T22:12:57Z
author avatar
Real User

Our primary use for this solution is to move data between points and applications.

2019-08-20T01:15:00Z
author avatar
Real User

We primarily use the solution for integration packages for ETL in order to build data warehouses.

2019-07-31T05:52:00Z
author avatar
Real User

We use this solution for extracting data from various databases and saving it in our data warehouse. We use the on-premise deployment model.

2019-07-31T05:52:00Z
author avatar
Consultant

We use the on-prem version of this solution. Our primary use case of this solution is for integrated data on the SQL server.

2019-07-31T05:52:00Z
author avatar
Reseller

We've used the solution to create some data flows for one of the governmental sectors here in Saudi Arabia. I have created some applications for exporting data from Oracle databases to SQL databases.

2019-07-31T05:52:00Z
author avatar
Real User

We use this solution for data warehousing. We are using the on-premise deployment model.

2019-07-30T10:41:00Z
author avatar
Real User

We use this solution for ETL, which includes data summation and cleaning. This solution used in an on-premise deployment, for now.

2019-07-30T10:41:00Z
author avatar
Real User

Our primary use is as an ETL tool to move data across our various environments.

2019-07-29T10:11:00Z
author avatar
Consultant

We primarily use the solution for data transformation.

2019-07-29T10:11:00Z
author avatar
Real User

I use this solution to create BI reports. I have used SSIS in more than twenty projects over the past six years.

2019-07-28T07:34:00Z
author avatar
Real User

The primary use case for this solution varies according to the customer, but it typically involves moving data from OLTP systems into a data warehouse and/or data marts.

2019-05-01T23:14:00Z
author avatar
User

SSIS is a very flexible solution that allows data to be generated through code or external software. As a result, we can create reproducible patterns and improve code quality.

2018-07-09T00:32:00Z
author avatar
Top 5LeaderboardConsultant

Movement of data and creation of files. ALl the typical things that you would have a ETL solution do. Data movements were in the millions and no calculations were completed. This means it was always a select * from where ever it was coming from and going to. Light translations like concatenation was being used.

2016-05-11T19:39:00Z
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
564,599 professionals have used our research since 2012.