Microsoft Flow

What is Flow?


Microsoft Flow is tool that allows one to create and automate workflows across multiple applications. To create a flow, the user specifies what action should take place when a specific event occurs. The most common use of flow is to trigger notifications. For example, flow can be used to send someone a notification when an item is added to a list.

Flows can also be used to collect data. For instance, if the user wants to see what people are saying about a particular brand, they can create a trigger that will capture new tweets that mention the brand and put a copy of each tweet into a database for further analysis. Once a flow is built, it can be managed on the desktop or through an app on a mobile device. Additionally, Flow can be integrated with other various Microsoft services. The Microsoft Flow Admin Center allows an administrator to manage users, permissions and roles and ensure that employee-created flows comply with data loss prevention policies. Continue reading “Microsoft Flow”

Creating SSIS Packages

Creating SSIS Packages

Recently I created SSIS packages to handle information from a spread sheet for a client. I finished making the packages, only to later realize there was a problem. One SSIS package added two tables to my database in order to handle changing the incorrectly typed value to the correct value in a specific column on any spread sheet. Lets use the following spread sheets to better describe exactly what I mean.screen-shot-2017-10-11-at-5-17-51-pm Continue reading “Creating SSIS Packages”