Great product to consolidate data for SQL Reporting purposes
May 03, 2021

Great product to consolidate data for SQL Reporting purposes

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Server Integration Services

We use SQL Server Integration Services to consolidate data from multiple vendor products. SSIS is the engine that gathers that data and stores it on our main SQL database instance for reporting purposes. It is being used by the enterprise in our organization. It created one pain of glass using SQL Reporting Services to show what systems are in what vendor products - such as agents installed yes/no? Last checking date/time, etc...
  • If the job fails, we are alerted
  • It has a easy to use GUI to build projects
  • Does well with gathering data from different types of data sets
  • Converting flat files of data requires a data transformation that is tedious
  • Saved our IT organization time by making reports of their their systems compliance.

Do you think SQL Server Integration Services delivers good value for the price?

Yes

Are you happy with SQL Server Integration Services's feature set?

Yes

Did SQL Server Integration Services live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of SQL Server Integration Services go as expected?

Yes

Would you buy SQL Server Integration Services again?

Yes

Moving data from one location to another. Also transforming data from one source to another destination. It wouldn't be needed for operating system file management or copying of files.

SSIS Feature Ratings

Connect to traditional data sources
7
Connecto to Big Data and NoSQL
5
Simple transformations
8
Complex transformations
7
Business rules and workflow
7
Testing and debugging
8
Integration with data quality tools
8