I provide services to create and design SQL Server Integration Services for data pre-processing and automation services. I have 10 years experience working with SSIS in big data environment, with SSIS I can sort out complex data so it ready to be presented by stored procedure. Using SSIS also I can automatically generate reports with specific format (JSON, XML, XLS etc.) and automatic email to recipients.

Within SQL Server Integration Services, I can provide:

• Pre-processing big data to optimize complex query performance
• Automate external processing under database layers, such automation sending email, messages, etc.
• Remap or data migration from one or more database into new database

SQL Server Integration Services can help company that have big data (millions or billions) to optimize their query performance by regularly scheduled pre-processing using SSIS. This services could simplify complex query structure so the data ready to be presented without complex joins. SQL Server Integration Services also can help automation without additional custom services/applications, it build integrated in Microsoft SQL Server as extended features. With this services we could automate sending notice for clients via emails or messages that before prepared using SQL Server Integration Services and automatic executed.

Tags: Microsoft SQL Server, SQL Server Integration Services, SSIS