SSIS Primary Use Case

Shubham-Agarwal - PeerSpot reviewer
Manager - Projects at Cognizant

We have a consolidated data warehouse. We use an SSIS tool as a pipeline to fetch the data from multiple sources such as Excel, CSV, Oracle database, or APIs. Further, we put the data into the SSIS database. We are using the solution for ETL purposes.

View full review »
BobAmy - PeerSpot reviewer
Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

We use SSIS to copy production data to Reporting Repositories. We use it for data movement from and to SQL or flat files such as CSV or fixed data.  This is primarily to build and update a data lake and data warehouse. 

More custom use cases are to do DQ validation comparing source to destination, and to extract data from bat files and SSIS files in order to build a metadata repository for documenting and mapping all the ETL packages.  We use this to find the packages responsible for any particular table or file, or vice versa.  This system, along with statistics logging, also gives us summary reporting capability.

View full review »
Sakiru Dosumu - PeerSpot reviewer
Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

We use SSIS for data extraction, transformation, and loading processes. This includes extracting data from various sources like Oracle and SQL Server, and then transforming it for use in reporting tools like Power BI dashboards. While we haven't directly migrated data between databases using SSIS, we have used it extensively for ETL tasks, such as extracting data for analysis and reporting purposes.

View full review »
Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Rohit Rastogi - PeerSpot reviewer
Lead Data Engineer at Capgemini

It was used for a couple of purposes, for example, we used it in our data warehouse when we wanted to create a dashboard that would give us an idea about, for example, the data itself. We had a client that would ask about a couple of requirements, like the past data from the last month or last year for a particular region for a particular client, and so on. I was using SSIS to store data incrementally and show the data using SSIS. 

For example, if we have created a couple of tasks or schedules, we would create a couple of packages and schedule them overnight. Every night it could fetch the data incrementally from the data warehouse. Every week, there was a requirement from the client that I need to add particular data to be changed and shared over email weekly. That particular data could be fetched from the data warehouse, and it will be shared with the client every week. 

View full review »
PALAK SURI - PeerSpot reviewer
Senior Software Engineer at Eurofins

We have some business requirements, and we use this solution to create the machine tables, measures and APIs.

View full review »
Krishna_Prasad - PeerSpot reviewer
Business Solutions Specialist at Kuwait Oil Company (K.S.C.)

We use this solution as an ETL tool to move large volumes of data from one server to another.

View full review »
Arpita-Mishra - PeerSpot reviewer
Specialist Software Engineer at a financial services firm with 10,001+ employees

We primarily use the solution for getting the data from the application database and to the OLAP system. We extract the data from OLAP system and build data warehouses. Basically, this solution is used to build OLAP.

View full review »
Eyal Golombek - PeerSpot reviewer
Database administrator at a recruiting/HR firm with 51-200 employees

Mostly we are receiving files in either XML or Excel and then we collect them in databases. Sometimes it's CSV and sometimes it is also Excel. Mostly, it is XML.

View full review »
Mylsamy T. - PeerSpot reviewer
Senior Associate - IT at Himalaya Wellness Company

The use case is related to all reporting and transactions. On an hourly basis, we will pull the data for a few reports. Most of the time, it is a real-time integration between the applications.

View full review »
Sakiru Dosumu - PeerSpot reviewer
Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

We are using SSIS for applications in development and in production. We have applications that need to have a database to support them and those applications need to have different integration with other applications.

View full review »
Ullas Soman - PeerSpot reviewer
DevOps Consultant at Coforge Growth Agency

I was using the solution to implement some business logic. What we do with the data collected is, for example, use it with Excel and some other databases. We do write our own logic to input the data into the SQL server. We'll be taking inputs and putting them into our business logic.

View full review »
Syed Fahad Anwar - PeerSpot reviewer
Principal System Developer at HHRC

We are using SSIS for ETL and ELT in a business intelligence context. We bring in data from different sources and use SSIS transform and load it into our intermediate database where we are developing dashboards. There are three people doing configuration and about 50 end-users. 

View full review »
DM
Data Architect at AMP Capital

We use SSIS to integrate investment data we collect from different places into our portfolio management system. We get results out of portfolio management systems and integrate that into the downstream back-office, risk, and regulatory reporting systems. All the developers at my company use it. 

View full review »
VS
Senior Associate at PwC Acceleration Centers

I am using SSIS for a primary database.

View full review »
Pavel Adam - PeerSpot reviewer
BI specialist at SKODA AUTO a.s.

One of our primary use cases is working with issues related to the electronic components of cars.

View full review »
SR
IT Manager at European University

We use the product sometimes to implement some ETL processes.

We have to transform some data from students so that we can help to make some decisions on what we call deterioration. We receive a lot of data from the government, and sometimes we have to split it into several parts as it is a huge amount of data. We have to put it in a standardized way. We use the solution as a product. It is one of the use cases that we do. When we have other systems, like for staff to control, we also use SSIS since it's appropriate to our system, and we need to put it in certain ways so that we can read it and manage it. 

View full review »
MB
Sr. Training Manager with 201-500 employees

Our company sells contracts when you buy a car. We sell aftermarket insurance for the tyre, wheel, ding, dent, windshield, etc. When somebody buys a contract, we capture all of that data into a legacy database PostgreSQL, and my task is to incorporate that into our financial platform using T-SQL. So, I write queries, procedures, and views. I use SSIS, and I use SSRS. My job is to get the data into our financial system so that we can process claims, payments, cancellations, and refunds.

View full review »
AS
General Manager IT at a manufacturing company with 10,001+ employees

SSIS is mainly used for data migration transfer.

View full review »
LD
IT Project Management /Research & Development Team Leader at Ethiopian Roads Administration

The one internally also developed some applications for some specific problems. For that use case, we are using the solution for different purposes, for example, for integration between data disks to databases, as well as for the application level side of integration. We are using the SSIS service actually. And we also have different expertise on the database level. We're also using it for different scenarios. We use it with Microsoft products. It's a part of our strategy, in the data aspect.

View full review »
SB
Admin at IEC (Electoral Commission of South Africa)

SSIS is helpful when you have tasks in a particular workflow that need to be completed on different schedules. You can start a specific task, and SSIS goes through the workflow to check a few things before it decides whether the task needs to proceed. Right now, maybe a quarter of the company is using it, but we plan to expand use in the future. 

View full review »
TY
Technical Consultant at LinkDev

The solution is a business application. It's used for integrations between different databases, migrating from one to one, and importing data from one thing to something else.

View full review »
Waqar Malik - PeerSpot reviewer
System Analyst at National University of Sciences and Technology

I use the company's solution to build dashboards and back-end data integration with Microsoft SQL Server and Power BI.

View full review »
Dhruv Singh - PeerSpot reviewer
Senior Architect (Data and AI) at a tech services company with 1,001-5,000 employees

The solution is primarily used for the ETL process. Another use case is transforming data from one format to another format.

View full review »
ArturKowalczyk - PeerSpot reviewer
Technology Innovation Leader at Netrix S.A.

SSIS orchestrates data transformation in the environment, which includes Oracle and SQL Server databases.

View full review »
YY
Manager, Data & Intelligence Group, Technical at a consultancy with 10,001+ employees

This is an infrastructure tool and our primary use case is for data warehouse integration.

View full review »
EL
BI Architect at a retailer with 10,001+ employees

We primarily use SSIS to collect data from one system and transfer it to another.

The Classical ETL processing of data.

View full review »
MB
Project Lead Performance Engineer & Automation at a insurance company with 10,001+ employees

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

View full review »
BA
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 »
Elena Tejadillos - PeerSpot reviewer
IT Officer in Data Science at United Nations

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 »
AltanAtabarut - PeerSpot reviewer
ECommerce Growth Analytics at Akinon

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 »
Pavan Yogender - PeerSpot reviewer
Founder and CEO at Zertain

We use SSIS for transformation and migration.

View full review »
BillyJohn - PeerSpot reviewer
Data Engineer at DataHyv

We're SSIS for flat file data ingestion. Our data sources are Excel files, but if the data sources are SQL servers, I use store procedures instead of SSIS packages.

View full review »
MJ
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. 

Now SSIS has introduced Big Data and cloud components. Though we haven't used any of these yet but it's really a very good addition to enhance SSIS capabilities.

View full review »
IL
Data Engineer at a tech services company with 11-50 employees

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.

View full review »
SP
Principle Consultant at Keyrus South Africa

We primarily use the solution for data transformation.

View full review »
BD
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 »
MP
Senior Analyst at a tech services company with 1,001-5,000 employees

We have data that needs to be migrated. There is also a scan inventory. We create web data, pull it, search it, and then find answers and report stakeholders. So for this process, we use the SSIS.

View full review »
IS
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 »
Lucas Dreyer - PeerSpot reviewer
Data Engineer at BBD

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 »
it_user342606 - PeerSpot reviewer
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 »
VD
student at University of Newcastle

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.

View full review »
Edgar Talom - PeerSpot reviewer
Information Technology Support Engineer/ Implementation Analyst /DBA at a tech services company with 11-50 employees

We use SSIS to migrate from an old server to a new one and to add some services. 

View full review »
AS
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 »
SA
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 »
it_user1048011 - PeerSpot reviewer
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 »
Celine Meesseman - PeerSpot reviewer
Director at Ingenia

We are a solution provider and SSIS is one of the products that we implement for our clients. I work as an integrator and a data flow developer.

SSIS is primarily used as part of the data flow for loading data into the data warehouse and exchanging data between applications.

View full review »
Shivani Pandey - PeerSpot reviewer
Consultant at Veear Analytics pvt limited

I have used this solution for integrating SQL into life insurance projects.

View full review »
Serdar Erdurak - PeerSpot reviewer
Information Zone Leader at digitallency

I am an ETL developer working as an information zone leader. We are an outsourcing company to our customers.

View full review »
RS
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 »
JF
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 »
Alexander Samuel Larico - PeerSpot reviewer
Teaching Professional at Next Idea Lab

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.

View full review »
it_user1080627 - PeerSpot reviewer
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 »
Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.