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!

Guest
1818 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
Top 5Real 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 5LeaderboardReal 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
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
Top 20Consultant

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
Top 20Real 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
Top 20Reseller

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
Top 5LeaderboardReal 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
Top 20Real User

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

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

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
Top 5Real 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: April 2020.
442,845 professionals have used our research since 2012.