3.8 out of 5 (19 Ratings)

15 Verified Reviews

SQL Server Integration Services

Excellent ETL tool

I like the application because you can connect to a variety data sources, and you can multi--thread and loads a variety of data sources at the same time. However, the application does crash when you run out of space.

SQL Server Integration Services

SQL 2016 Integration Services

We have recently upgraded our SQL integration service to SQL 2016 and we're very happy with new version.

SQL Server Integration Services

Implementation was easy, but get ready for long running hours for large amount of data

it was good, easy and relevant. only thing is performance is comparitively slow.

SQL Server Integration Services

Easy start with some limitations on connecting to mainframe

Very easy to start with in terms of installation, infrastructure. Worked very well with SQL Server. Had challenges connecting to mainframe like DB2 and IMS. Overall, very good.

SQL Server Integration Services

As part of SQL Server install, very straightforward

Very seemless install and integration into our systems

SQL Server Integration Services

I always think I'm going to like SSIS better than I do

I tend to end up putting tsql into a SQL Script task - not much different than scripting. It is easy to deploy and schedule through SQL Server - that is the best part

SQL Server Integration Services, Other...

Implementation is easy!

We are SQL Server from last couple of years and now thinking of movig to AWS becuase of SQL Server licences cost and other hardware related expences on primise.

SQL Server Integration Services

Easy implementation and smooth roll out.

We have implemented an enterprise-wide solution for jobs to integrated data across multiple platforms but mainly SQL Server databases. It was smooth and flawless and we were able to integrate the necessary security to make this an enterprise solution.

SQL Server Integration Services

Implementation was easy but could have been alot simpler.

I believe there are still a few areas where Microsoft can work to improve the product. In particular the web service integration is very limited and requires extensive scripting to compensate for it.

Other...

Robust product and cheap but the development effort is high and developers are expensive and hard to find

Microsoft didn't engage in a way that was satisfactory when we had questions and/or problems with the product.