--- title: Microsoft SQL Server Integration Services to Alation Reviews meta\_title: 'Microsoft SQL Server Integration Services to Alation Reviews 2026: Details, Pricing, & Features | G2' meta\_description: Filter 85 reviews by the users' company size, role or industry to find out how Microsoft SQL Server Integration Services to Alation works for a business like yours. aggregate\_rating: rating\_value: 4.2 review\_count: 85 scale: '5' date\_modified: '2026-08-09' parent\_category: name: Marketplace Apps url: https://www.g2.com/categories/marketplace-apps --- # Microsoft SQL Server Integration Services to Alation Reviews & Product Details Shows the lineage between Table to File, File to Table and Table to Table of Microsoft SQL Server Integration Services jobs in Alation. * * * Seller [Information Asset, LLC.](https://www.g2.com/sellers/information-asset-llc-4d9cda0f-fdfa-4e95-a15f-b875f989b923) Discussions [Microsoft SQL Server Integration Services to Alation Community](https://www.g2.com/products/microsoft-sql-server-integration-services-to-alation/discuss) Solution Type Best-of-Breed Show More ## Value at a Glance Averages based on real user reviews. ### Time to Implement 3 months ### Return on Investment 10 months [ View More Pricing Information ](https://www.g2.com/products/microsoft-sql-server-integration-services-to-alation/pricing) ## Top-Rated Alternatives [ ![SolarWinds Database Observability](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "SolarWinds Database Observability") SolarWinds Database Observability 4.5/5(231) ](https://www.g2.com/products/database-observability/reviews) [ ![Azure Analysis Services](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Azure Analysis Services") Azure Analysis Services 4.4/5(157) ](https://www.g2.com/products/azure-analysis-services/reviews) [ ![Azure Monitor](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Azure Monitor") Azure Monitor 4.3/5(108) ](https://www.g2.com/products/azure-monitor/reviews) [ View All Alternatives ](https://www.g2.com/products/microsoft-sql-server-integration-services-to-alation/competitors/alternatives) ## User Insights Average based on 85 real user reviews. Implementation Time 3 months [Log in to unlock pricing and user insights](/login) ![Aman J.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Aman J.") AJ Aman J. Software Developer Computer Software Small-Business (50 or fewer emp.) 6/19/2024 "Its a Good Company Microsoft SQL Server" 5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? Real visibility, clear data lineage, and better collaboration across teams. Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? There’s a lot of setup and ongoing maintenance overhead. Support is weak. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? Source systems, downstream dependencies. Review collected by and hosted on G2.com. Show More Our network of Icons are G2 members who are recognized for their outstanding contributions and commitment to helping others through their expertise.G2 Icon 4/27/2026 Validated ReviewerIncentivizedSource: G2 invite ![Anumesh S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Anumesh S.") AS Anumesh S. Senior Business Intelligence Developer Small-Business (50 or fewer emp.) 6/18/2024 "Microsoft SQL Server Integration Service Integration tool" 4.5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? Microsoft SQL Server Integration Service Integration tool is a good integration tool I reccomned to all integration users Code wise also it's very easy compared to all etl tools Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? everything is good but the UI is slow sometimes. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? No problems occured till now but the UI is slow sometimes Review collected by and hosted on G2.com. Show More 4/21/2025 Validated ReviewerIncentivizedSource: G2 invite ![Laurence R.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Laurence R.") LR Laurence R. Data Analyst Small-Business (50 or fewer emp.) 6/18/2024 "How Microsoft SQL Server Integration Services to Alation changes how we manage data" 5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? The most helpful thing about the Microsoft SQL Server Integration Services to Alation is the efficiency it provides for data integration and data transformation. Handling data, especially large amounts of data, has always been very challenging. With the help of this tool, we can achieve our goal of data management with ease. Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? I think the only downside of the Microsoft SQL Server Integration Services to Alation is the need to research and study how to properly use it to maximize potential of data management. However, such downside is easily resolved by hardwork and determination to fully utilize the tool as it is a very efficient tool. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? Microsoft SQL Server Integration Services to Alation solves our problem of handling large amounts of data that needs a lot of cleansing and mining. This tool has been very efficient in managing data. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerIncentivizedSource: G2 invite RD ritik d. Data Analyst Mid-Market (51-1000 emp.) 7/8/2024 "Concise and Keyword-rich" 5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? As a data analyst, the best part of linking SSIS with Alation is like having a map for your data. It automatically tracks where your data comes from and what happens to it, saving you time and headaches! Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? While the benefits are great, there's a catch. SSIS and Alation don't connect seamlessly out of the box. You'll need extra tools or custom coding to bridge the gap. This can be technical work and might require some IT muscle. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? As a data analyst, my biggest headache used to be remembering what goes on in all my SSIS data pipelines. Imagine building these complex things that move data around, but then months later someone asks where a number comes from, and you're stuck digging through code. Alation with SSIS (it needs a little extra setup) fixes that! Alation acts like a GPS for your data, automatically showing where everything comes from and what happens to it. No more code diving! Plus, Alation stores all the details about my SSIS pipelines in one place, so everyone's on the same page. This saves me tons of time, cuts down on errors, and makes working with data so much smoother. Sure, it's not magic, but it's pretty darn close for us data analysts! Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Giridhar P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Giridhar P.") GP Giridhar P. Data Engineer Enterprise (\> 1000 emp.) 6/18/2024 "MS SSIS to Alation is a great tool for data integration and business analytics needs." 4.5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? MS SSIS to Alation enables data integration from multiple sources in a seamless fashion. The tool procures a connection with data catalog tool Alation and enables the user to import data from table to file or vice versa or table to table job. It also depicts the lineage between all of these objects including the attribute level mappings and keys. All the more, this product is offered as a SAAS solution wherein the user doesn't have to bother about infrastructure provisioning. Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? MSQL to Alation is an expensive product for small scale start ups. The org needs to explore the features and charateristics before purchasing the same. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? MS SSIS to Alation is helping our analytics team in getting 360 view of the source dataset and the transformed one at the normalized layer. It's able to display the attribute mappings and lineage from the source all the way till the destination including any temporary hops. The tool also assists in the Data quality and governance aspects owing to its integration with Alation and assists the team in holisting aspects of business decision making. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Meenakshi S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Meenakshi S.") MS Meenakshi S. Manual Tester Small-Business (50 or fewer emp.) 6/27/2024 "SQL - Specific Sequence" 4.5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? Microsoft SQL server is a perfect tool which helps us to maintain & Discover Data. This tool not only improves data processing efficiency but also provide us a easy way to search the data. Microsoft SQL server tool is essential for data migration. Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? Microsoft SQL tool Memory usage is high due to which the SQL server run slow. Microsoft SQL server integration tool is not compatible when use with JSON. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? We as a organistaion using it for all the data Mining work, downloading data and to make change in App subscription in test servers. we are managing the data through Microsoft SQL server integration service tool. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerIncentivizedSource: G2 invite ![Venus M.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Venus M.") VM Venus M. IT SPECIALIST Small-Business (50 or fewer emp.) 6/19/2024 "Efficient Platform for Data handling" 5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? I really like that this is the most Powerful platform for building high performance data integrations solutions. and data migration tool that comes with Microsoft SQL server database that used to extract, assemble and transform data. This integration tool really helps in solving complex business problems and improvesproductivity and efficiency. The implementation of this tool is super easy to use and on every day basis I am using it frequently. Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? So far I have not encountered any major drawbacks with this tool so I really do not feel any cons of this. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? This has really helped inexecutingmultiple tasks on every day basis. It helps me in migrating data, transform and assemble data including databases and cloud based applications. It can also encrypt files, send files to other network locations so overall provides consistency and reduce manual errors. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Hazel D.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Hazel D.") HD Hazel D. Outreach Specialist Mid-Market (51-1000 emp.) 6/18/2024 "A very helpful tools for us!" 5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? It makes my work more easier and more convenient. It gives me relevant and legit details of the information that I really needed. I'm so happy using this product and thank you for making this great and one of a kind tools. Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? I don't have specific things that I don't like about it. But there are some things that need to improve. Hope it will go smoothly. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? Solving the problems and statistic made easy because of this. It really benefits you in all ways because it can give relevant answers on all your needs. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerIncentivizedSource: G2 invite AA Ajenthan A. Manager - IT Building Materials Mid-Market (51-1000 emp.) 6/18/2024 "Best intergration tools for data management" 4.5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? Being able to obtain complete data traceability is one of the most valuable aspect of combining SSIS with Alation. Users can see the complete data flow from source to destination by combining both. Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? Two thinks which is complicated. One is difficulty of configuring and maintaining the integration, integrating Microsoft SQL Server Integration Services with Alation might be difficult. The integration also be affected by upgrades or modifications made to either system, needs continuous administration and troubleshooting. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? Clear data lineage and centralized data management, improved data governance and compliance, and improved teamwork and documentation among data teams are few possitive outcomes by intergrating both helps to address the difficulty of tracking and managing complex ETL processes. Review collected by and hosted on G2.com. Show More 6/21/2024 Validated ReviewerIncentivizedSource: G2 invite ![Mahesh B.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Mahesh B.") MB Mahesh B. Senior Analyst and Consultant Enterprise (\> 1000 emp.) 6/18/2024 "Best graphical Integration Services with Altation" 4.5/5 What do you like best about Microsoft SQL Server Integration Services to Alation? Microsoft SQL Server Integration Services (SSIS) is a Low code Enterprise level tool with ease of usage and integration. It has graphical Integration Services to convert any type of data. Altation is data analysis too and with these tools the frequency of usage of SSIS is very high and accurate.With Being Low code the implementation is very easy and the support provided is phenomenol. Review collected by and hosted on G2.com. What do you dislike about Microsoft SQL Server Integration Services to Alation? The pacakage is limited thee are few additional features which can be implemented. Review collected by and hosted on G2.com. What problems is Microsoft SQL Server Integration Services to Alation solving and how is that benefiting you? We were facing issues on marketplace with graphical Integration Services and SSIS came as the best tool for us resolving our integration issues. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ## Questions about Microsoft SQL Server Integration Services to Alation? Ask real users or explore answers from the community Get practical answers, real workflows, and honest pros and cons from the G2 community or share your insights. [ Ask about Microsoft SQL Server Integration Services to Alation ](https://www.g2.com/products/microsoft-sql-server-integration-services-to-alation/discussions/new) GU Guest User • Last activity almost 2 years ago What is Microsoft SQL Server Integration Services to Alation used for? 0 Upvotes 1 [ Join the conversation ](https://www.g2.com/discussions/what-is-microsoft-sql-server-integration-services-to-alation-used-for) [ View all Discussions ](https://www.g2.com/products/microsoft-sql-server-integration-services-to-alation/discuss) ## Pricing Insights Averages based on real user reviews. ### Time to Implement 3 months ### Return on Investment 10 months ### Average Discount 18% [ View More Pricing Information ](https://www.g2.com/products/microsoft-sql-server-integration-services-to-alation/pricing) ## Work at Information Asset, LLC.? Claim this profile to respond to reviews, update product info, and reach in-market buyers. [ Claim this profile ](https://www.g2.com/products/microsoft-sql-server-integration-services-to-alation/claim_requests/new?utm_medium=profile-footer-claim-cta&utm_source=g2) ##### Categories on G2 [AWS Marketplace](https://www.g2.com/categories/aws-marketplace)[Other Analytics](https://www.g2.com/categories/other-analytics) ##### Explore More [User-friendly virtual event solutions for small businesses](https://www.g2.com/discussions/user-friendly-virtual-event-solutions-for-small-businesses)[What PLM software do companies supplying to aerospace primes typically use to stay compliant with AS9100 and customer-specific data requirements?](https://www.g2.com/discussions/product-lifecycle-management-plm-which-plm-platforms-are-the-best-fit-for-aerospace-and-defense-companies-that-need-configuration-mana%20)[Which job description management software offers the most customizable templates?](https://www.g2.com/discussions/which-job-description-management-software-offers-the-most-customizable-templates) [What is the best software for improving employee engagement in the service sector?](https://www.g2.com/discussions/what-is-the-best-software-for-improving-employee-engagement-in-the-service-sector)[Which encryption software combines email encryption with secure file sharing capability for teams?](https://www.g2.com/discussions/which-encryption-software-combines-email-encryption-with-secure-file-sharing-capability-for-teams)[Which apparel business management and ERP platforms integrate with e-commerce platforms, EDI systems and third-party partners without custom development?](https://www.g2.com/discussions/which-apparel-business-management-and-erp-platforms-integrate-with-e-commerce-platforms-edi-systems-and-third-party-partners-without-custom-development) [Show MoreShow Less](javascript:void(0);)