SSIS Reviews

What do you think of SSIS?

Sql Server Integration Services (SSIS) 2016 Review Summary SSIS 2016 - the Good the Bad, and the Ugly SSIS is a unique ETL tool for a number of reasons. Most shops already own it but may treat it as a one-off free utility rather than as an enterprise ETL tool even though it can compete with the best of ETL tools. Some of the lack of respect is due to immature beginnings in its former "DTS" days. And some of it is because it comes bundled with Sql Server and does not normally run (but can) on a separate ETL server.  It can't be good if its free right?  Especially when competitors easily charge 6 figures for  their tools. Don't we get what we pay for?  My answer is, generally yes but this may be an exception worth noting. SSIS has become extremely flexible, extensible...

What do you think of SSIS?

Primary Use Case 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. • Improvements to My Organization SSIS was easily adaptable to our group. It was cheaper than the other tools that we compared it to, however I feel that we got what we paid for. • Valuable Features The packaging and how it is organized is good for someone that really has never seen ETL before.  • Room for Improvement Scalability of SSIS needs some improvement. Seems to get sluggish as soon as we hit a high volume of data. • Use of...

What do you think of SSIS?

Primary Use Case 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. • Improvements to My Organization Because of the code generation, code quality improved and the time to develop decreased. This led to a quicker and more agile development phase. • Valuable Features It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud. • Room for Improvement Metadata management. A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened. • Use of Solution More than five years.