Our use of SSIS
November 24, 2019
Our use of SSIS
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
We use SQL Server Integration Services to import data into and out of our main SQL server databases. This data comes from a variety of external sources and sometimes there is data format mismatch between source and destination. With an SSIS package, we can retain the mapping and data formats integrity from the source to the destination without having to go through the process every time.
- Easy to manage projects and packages.
- Ideal for repetitive tasks.
- Can handle complex tasks consisting of multiple, diverse packages.
- Include SSIS in the default installation of SQL.
- The flexibility and different packages and options can make it confusing for first-time users.
- Recommendations in the selections could make it easier to build a solution.
- Positive - easier to manage and maintain data imports and maintain consistency over time.
- Positive - reusable projects reduces time for repetitive tasks.
- Negative - learning curve. Variety and flexibility of possible solutions can be overwhelming.
We selected SSIS as it came part of our standard SQL license. We did not evaluate any other solutions as SSIS has met all our needs.
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