Elena Tejadillos - PeerSpot reviewer
IT Officer in Data Science at United Nations
Real User
Simple to install and has support for SQL views
Pros and Cons
  • "There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
  • "The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."

What is our primary use case?

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

What is most valuable?

There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information.

What needs improvement?

I have had problems in the past with this tool. The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information.

The main difficulty that I have had is to match different data types, where there were errors that I could not fix.

I would like to see better integration with the control sources. 

For how long have I used the solution?

We have been using SSIS for ix years.
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,234 professionals have used our research since 2012.

How are customer service and support?

I am satisfied with the technical support for this solution.

How was the initial setup?

The initial setup of this solution is quite simple.

What about the implementation team?

We handled the installation of this solution in-house.

What other advice do I have?

Overall, I am quite satisfied with this product.

I would rate this solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
CEO at Shiraz University
Real User
Top 20
User-friendly solution with a good dashboard
Pros and Cons
  • "It's already very user-friendly and has a good dashboard."
  • "Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."

How has it helped my organization?

This product is always used in projects because I'm in a company that develops software for other companies and we accept this type of work like programming and developing data models and writing the script for organizations to transfer their data between databases. We usually use these tools, and it's a cheap tool for us.

What is most valuable?

Usually, when I want to import data from other databases I use this solution. It's been about fifteen years that I've worked with an SQL server, and I'm a software developer. I've had many companies with different databases, and it's ranged from FoxPro, EDX and Oracle, and some other databases. When I want to import data I usually use this tool for importing data from the other databases to the server. It is really good, and it's solved many problems for me because I can choose the source table, destination table, source field, and destination field. I can match these things, I can write some queries to do this and because of that, I use this tool.

What needs improvement?

Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines and SSIS now doesn't seem to support it in our databases.

In future releases, it would be helpful to support new SQL databases. It would also be helpful if there was a way to use SQL with other languages like Python or ASP.NET.

For how long have I used the solution?

I've been using the solution for 15 years.

What do I think about the stability of the solution?

The stability is very good and I recommend it to my friends, my coworkers, and the other companies.

What do I think about the scalability of the solution?

The solution is scalable.

How was the initial setup?

The initial setup was very easy for us and very good.

What about the implementation team?

I installed the solution by myself.

What's my experience with pricing, setup cost, and licensing?

The price is important to us. We are based in Iran, and we look for products with a good price because of the sanctions. Some other products such as Oracle are expensive here and we do not recommend these products to our customers. They are expensive and they are very difficult to work with them. They are very difficult and very complicated but Microsoft products are not like that.

Which other solutions did I evaluate?

I used this product when I was a student so I chose this technology because I understood it best. 

What other advice do I have?

We chose the solution because we have some data in Oracle and we wanted to extract it and load the data into SQL Server

The type of port, like SSIS, I always recommend other companies to use it and other Microsoft products because they are very easy to use. There are very handy tools. It's very user-friendly and has a good dashboard.

I would rate the solution nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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,234 professionals have used our research since 2012.
AltanAtabarut - PeerSpot reviewer
ECommerce Growth Analytics at Akinon
Real User
Top 5Leaderboard
Has the potential to expand so that you can immediately write code onto the SQL server
Pros and Cons
  • "With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
  • "The solution should work on the GPU, graphical processing unit. There should also be piping integration available."

What is our primary use case?

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.

What is most valuable?

With this solution, there is the potential to expand so that you can immediately write code onto the SQL server. Auto-parallelization is also critical for us. It decides automatically how many parallel sessions you have to run to get your query handled. You don't need to take care of any code, which is ideal. It's also highly scalable.  

What needs improvement?

The solution should work on the GPU, graphical processing unit. There should also be a piping integration available.

The design of the dashboard isn't great, visually, but the solution works, so this isn't so important to me.

SSIS's competitor, Autonomous Database by Oracle, offers you, depending on the performance of the server, new hardware, should you update your software. It advises you on how to optimize your system. It's AI and works as an artificial database manager. Microsoft doesn't have anything like this yet, but it would be nice if they did.

For how long have I used the solution?

I've been using the solution since 2008 or 2009.

What do I think about the stability of the solution?

The stability of the solution is perfect.

What do I think about the scalability of the solution?

The solution is very scalable. We have approximately 25-30 users for the on-premises version, and our cloud version has around 5,000 users.

How are customer service and technical support?

We don't ask for much from technical support. We utilize community information, and source answers via the internet or online user information. I do find that communicating with Oracle is much better.

Which solution did I use previously and why did I switch?

We previously used Oracle as an integration tool, but it's much more expensive than Microsoft.

How was the initial setup?

The initial setup was easy.

What about the implementation team?

We had a consultant that assisted us with the implementation.

What other advice do I have?

I use the private cloud as well as the on-premises version of the solution.

I would rate this solution eight out of ten. I would rate it higher if the solution offered full automation AI for database managing, setup and management, and scaling of the solution.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Pavan Yogender - PeerSpot reviewer
Founder and CEO at Zertain
Real User
Top 5
A stable and scalable solution that can handle real complex transformations
Pros and Cons
  • "The most valuable feature of SSIS is that it can handle real complex transformations."
  • "SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

What is our primary use case?

We use SSIS for transformation and migration.

What is most valuable?

The most valuable feature of SSIS is that it can handle real complex transformations.

What needs improvement?

SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it.

For how long have I used the solution?

I have been using SSIS for more than 10 years.

What do I think about the stability of the solution?

SSIS is a stable solution.

What do I think about the scalability of the solution?

SSIS is a scalable solution.

How was the initial setup?

The solution's initial setup is easy, but you'd need expert-level knowledge to work on it.

What other advice do I have?

Overall, I rate SSIS an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
BillyJohn - PeerSpot reviewer
Data Engineer at DataHyv
Real User
Top 20
It's easy to use but setting up a large number of tables and columns can get cumbersome
Pros and Cons
  • "SSIS is easy to use."
  • "SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

What is our primary use case?

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.

What is most valuable?

SSIS is easy to use. 

What needs improvement?

SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model. 

For how long have I used the solution?

I have used SSIS for three or four months. 

What do I think about the stability of the solution?

SSIS is a stable product, but the problem is with the UI you use to build things. If you have it deployed on a virtual machine, everything crashes sometimes. That's one of the significant problems we face with Microsoft products.

What do I think about the scalability of the solution?

We have problems with the ports for the analysis services. If everything is deployed, you need to redeploy. It's hard to scale out. If you plan to scale up, you need to prepare everything correctly from the start. Everything needs to be properly configured and deployed. 

Which solution did I use previously and why did I switch?

We decided to use SSIS because most developers know SQL Server. If they need to hire data engineers, they can just use generic languages like SQL Portal. You don't need to know Talend or other data warehouses and database engines. They prefer SQL Server because that's the most common product.

How was the initial setup?

Setting up SSIS is difficult. I rate it seven out of 10 for ease of setup. It takes around a week to setup a simple data warehouse with three tables. 

What other advice do I have?

I rate SSIS six out of 10. SSIS can get the job done for bigger datasets. However, SQL Server lags if you're working with more than a terabyte or petabyte of data. I recommend exploring the tool because most of the video tutorials on the internet are outdated, and the official Microsoft documentation is geared toward advanced users. Beginners will have a hard time. You need a senior engineer to teach you, or you must explore the tool on your own.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Vichitra Mohan - PeerSpot reviewer
Technical Service Team Manager at a tech vendor with 10,001+ employees
MSP
Top 20
Excellent reporting services
Pros and Cons
  • "SSIS' most valuable feature is its reporting services."
  • "SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

What is most valuable?

SSIS' most valuable feature is its reporting services.

What needs improvement?

SSIS sometimes hangs, and there are some problems with servers going down after they've been patched.

For how long have I used the solution?

I've been using SSIS for over eight years.

What do I think about the stability of the solution?

SSIS' stability is fairly good, but there's room for improvement.

How was the initial setup?

The initial setup was pretty simple.

What's my experience with pricing, setup cost, and licensing?

SSIS is fairly well-priced - I would rate it at four out of five.

What other advice do I have?

SSIS is best suited for small and medium companies. I would rate SSIS eight out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Senior Manager Software Development at Techlogix
Real User
While you can build your own components, that is not straightforward
Pros and Cons
  • "The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
  • "It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."

What is our primary use case?

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.

How has it helped my organization?

SSIS is a tool which anybody can learn in no time. When we started the project, the whole team learnt it in one week's time and then were ready to start on project tasks. It gives you control. Recently, we used SSIS for a compliance project where we performed data cleansing and extensive data transformations to prepare data files for use of compliance (Trade Based AML solutions) application.

What is most valuable?

Script task and Script component for custom tasks: It gives you power to build your own logic if your requirements are not being fulfilled with existing available components. While the big thing is you can build your own components, that is not so straightforward. 

It's visual design interface is good and you can easily understand the flow. 

The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline. It has good logging capabilities as well.

What needs improvement?

It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well. 

We couldn't explore big data related components, and this area should be up to the mark, if not already. Certain data quality checks should also be part of it. Currently, this is the biggest area that should be looked into. Data quality is an essential part of the integration process and ETL. Currently, only the data profiling task is there. 

As an update, now SSIS offers big data components as well. 

For how long have I used the solution?

5+ years.

What do I think about the stability of the solution?

I've been using it for last 7 years in different projects for different banks. Didn't face any stability issues yet.

What do I think about the scalability of the solution?

Yes. It's very much scalable, but it all depends on how you design your solution. SSIS provides you extensive features and toolkit to handle all sort of data problems.

Which solution did I use previously and why did I switch?

I also used Oracle Data Integrator as an ETL tool but it all depends on your need and customer preference. SSIS is being easy to use and things can be developed very quickly so I prefer to use SSIS for most of my data related tasks.

How was the initial setup?

Its setup is very easy. You don't need too many components to start building ETL tools. Plus, there are a lot of online learning available for this tool. It can be deployed on any Windows machine with minimal requirements.

What's my experience with pricing, setup cost, and licensing?

If you have SQL Server License then you can use SSIS without any additional cost.

What other advice do I have?

Overall, we remained in a good position and in control while using SSIS. We didn't face any challenges.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Data Engineer at a tech services company with 11-50 employees
Real User
Good support, user-friendly, and easy to integrate with Microsoft tools, but needs a better console, more features, and better capability to handle a large volume of data
Pros and Cons
  • "The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
  • "It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
  • "When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

What is our primary use case?

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.

What is most valuable?

The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products.

It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world.

What needs improvement?

When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. 

Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console. 

How are customer service and technical support?

Microsoft is good in terms of technical support. They provide 24-hour support. They have built a large community all over the world, and one can find easily the answer to an issue or problem by searching on the web.

How was the initial setup?

Its installation wasn't my job. We have a team that specializes in infrastructure, and they install and set up the tool. When I was a student, I used to install it myself, and it wasn't really difficult, but I have not installed it on a professional site or for a company. 

What's my experience with pricing, setup cost, and licensing?

Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS.

SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free.

What other advice do I have?

I would rate SSIS a six out of ten. I prefer Talend over SSIS.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free SSIS Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
Product Categories
Data Integration
Buyer's Guide
Download our free SSIS Report and get advice and tips from experienced pros sharing their opinions.