Are you running a Microsoft SQL Server to keep track of your business records? Have a ERP or CMS management system and want to automate tasks? Let me introduce you to SQL Server Integration Services (SSIS). SSIS is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. It allows for programming logic to be mixed with C# to leverage SQL queries for business needs.
Over the past two months I have generated many SSIS packages to reduce manual data entry and to create a set of alerts to optimize business practices. Packages where used to update fields for predicted inventory burn out dates daily. Reports where created to alert staff of inventory arrival and approval for put away. Additionally warning alerts where created to check system availability statuses and to flag user error in the warehouse. With C# one is able to build dynamic HTML5 emails to present SQL query data in a friendly end user way.