Data Solutions at its Best!!
June 25, 2022

Data Solutions at its Best!!

Abhinav Choudhary | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

So we are a data company where in almost a terabyte of data is generated everyday. The data that is procured is shared with the customers in varied forms such as text file, csv etc. SQL Server Integration Services gives us the ease and flexibility to export the data and choose our respective format within some clicks.
  • Data Migration
  • Flexibility to choose columns and rows
  • Add a Pivot to our data
  • Fuzzy Logic sometimes doesn't work properly, It can be improved.
  • The column extraction can be more flexible in terms of data types
  • The UI sometime hangs if data is huge or processing is too large.
  • Worth the Money spent.
  • Some time becomes tedious due to clicks.
  • Have made data extraction a breeze.
The only reason for choosing SQL Server Integration Services was the simple usage without many complications, Its easily accepted by Users, Gives us the complete flexibility migrate data and choose its format. Google products have a high cost and are prone to down times as we have observed. SQL Server Integration Services was suiting our business purpose both internally and externally.

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?

Yes

Did implementation of SQL Server Integration Services go as expected?

Yes

Would you buy SQL Server Integration Services again?

Yes

We use it majorly for data migration to other DB that we have internally and Data mining and export of data as we require it for various analyses. If your data is not wrangled correctly it becomes a big task to rectify and then use the SQL Server Integration Services wizard for data extraction.

SSIS Feature Ratings

Connect to traditional data sources
8
Connecto to Big Data and NoSQL
8
Simple transformations
9
Complex transformations
8
Data model creation
8
Metadata management
9
Business rules and workflow
9
Collaboration
9
Testing and debugging
9
Integration with data quality tools
9
Integration with MDM tools
7