Analytic Vision

Microsoft SQL Server Integration Services

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions that is utilized to solve many complex business problems and common items including, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data (such as using cross-reference tables and performing allocations).  At Analytic Vision we leverage our experience to understand what techniques offer optimal performance, and we are very adept at developing custom code routines with Integration Services for dealing with complex data issues.

SQL Server Integration Services is a great tool for developing the ETL processes to load the data warehouse and it is extremely important to test the processes for accuracy and speed. We believe that the developer should understand what the expectations are for clean data, and that they ideally can identify unexpected data issues that sometimes are discovered when dealing with the real data. To assist this process we recommend developing audit queries that automatically tie the data warehouse data back to the source system whenever possible.

Integration Services is a cost effective alternative to higher-end ETL tools with the ability to handle a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.  As such, Integration Services is often an integral backend piece to large enterprise performance management and business intelligence implementations as well.

If you are looking for expertise advice regarding your data warehousing and SQL Server projects contacts us today. We have years of experience and the technical knowledge to provide you the answers you need. Contact us today!