SSIS Primary Use Case

SeniorBI67
Senior BI Developer at a music company with 501-1,000 employees
We use this solution for data warehousing. We are using the on-premise deployment model. View full review »
reviewer860583
Data Scientist at a tech vendor with 501-1,000 employees
We use this solution for ETL, which includes data summation and cleaning. This solution used in an on-premise deployment, for now. View full review »
AhmedShaban
Database Consultant
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. View full review »
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
455,962 professionals have used our research since 2012.
Globalmark677
Platform Lead: Global Markets Data Analytics at Rand Merchant Bank
Our primary use is as an ETL tool to move data across our various environments. View full review »
Muhammad Arif Javed
Senior Manager Software Development at Techlogix
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. View full review »
AltanAtabarut
Founding Partner at Altdata Analytics
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. View full review »
Sherif Abdelrehim
Data Architect and Modeler at a tech services company with 201-500 employees
We use this solution for extracting data from various databases and saving it in our data warehouse. We use the on-premise deployment model. View full review »
BIConsule1f7
BI Consultant at a tech services company with 201-500 employees
We use the on-prem version of this solution. Our primary use case of this solution is for integrated data on the SQL server. View full review »
Brian Dandeneau
Business Process and Strategy Specialist Advisor at NTTData
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. View full review »
Sasidhar Parupudi
Principle Consultant at Keyrus South Africa
We primarily use the solution for data transformation. View full review »
Igor Smirnov
Director at Netica d.o.o.
We primarily use the solution for integration packages for ETL in order to build data warehouses. View full review »
reviewer789228
BI and Report Development Technician at a tech vendor with 201-500 employees
I use this solution to create BI reports. I have used SSIS in more than twenty projects over the past six years. View full review »
Bob Amy
Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.
We use this solution to ingest data to a data lake that is built on SQL Server. View full review »
Steve Seeber
Senior Director Business Intelligence at Xtivia
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. View full review »
Ricardo_Silva
Big Data Architect, Integration Specialist at Groundswell Group Inc
Our primary use for this solution is to move data between points and applications. View full review »
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
455,962 professionals have used our research since 2012.