Previously, it took a lot of work to connect with multiple data sources. But now, we can connect with them easily using an external connector in SSIS.

I like that SSIS lets us build programs top-down. Starting with the control section, then drilling into the details of the steps make more sense than what Informatica requires, where you have to build each block first, then use a different tool to build the control structure.

In production, SSIS does a very good job of distributing work to many threads. It is robust and does a good job of handling overload conditions. It is simple for basic jobs, yet able to do very complex tasks. When all else fails, code can be written to make your own custom task or even tool.

I believe SSIS is not given the credit it deserves. SSIS does what most other new vendors tout as great features. But it is a very mature and stable product, unlike those others. It is supported by a larger company than many of those other products.

The error messages are pretty clear and point you to the problem well.

I am disappointed that Azure Data Factory did not stay closer to SSIS.

We have many regulations that we must follow, and this solution helps us manage that. There are rules that we must follow, and we get files in a uniform structure, and we need to import them into databases. Doing it with SSIS saves us a lot of time.

It is a very helpful tool to integrate. We can have our logic ready by putting data from different data sources, and based on our business requirements, we can have the logic created with the help of the SSIS package.

Not much but served as better alternative

The solution has enabled us to perform tasks more quickly.

SSIS seems easy to use, is freely available for programmers to learn on their own, and has a lot of resources on the web for any trouble you get into.

This product is always used in projects because I'm in a company that develops software for other companies and we accept this type of work like programming and developing data models and writing the script for organizations to transfer their data between databases. We usually use these tools, and it's a cheap tool for us.

SSIS utilizes SQL Server Management Studio (SSMS) for management. I've used SSMS for many years and find it quite user-friendly, even for those new to SQL Server.

SSIS is a tool which anybody can learn in no time. When we started the project, the whole team learnt it in one week's time and then were ready to start on project tasks. It gives you control. Recently, we used SSIS for a compliance project where we performed data cleansing and extensive data transformations to prepare data files for use of compliance (Trade Based AML solutions) application.

It's too early to say how it has improved my organization, as we've just begun using the solution. First, we need to create the appropriate role before we see organizational improvements. We're just in the discovery phase of the tool.

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.

Because of the code generation, code quality improved and the time to develop decreased. This led to a quicker and more agile development phase.

This solution allows us to be repeatable in the sense of how we move data from A to B. It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs. We also use it with Microsoft BizTalk, and it's quite handy.

• SSIS packages are stored in XML-like format; we keep them in SVN which makes it very easy to track changes
• Built-in dependency tool is really great; you can not only react to success/failure results, but you can evaluate any expression in the flow and execute (or bypass) any components based on the result of that expression. This gives you full control to build decision trees of any complexity

For the full version of the SQL Server, SSIS, SSAS and SSRS will come as additional features for free. Hence, my organization need not spend extra money for other ETL, reporting and analysis tools. This can give very good flexibility.

This is a flexible tool to use and comes with the MSSQL server package.

This solution has provided an inexpensive tool and it is easy to find experienced developers.