Greetings everyone! As you may have seen in our recent summer release blog, there are a lot of features new to our tools. Today, we're going to have a look at another fantastic tool from our Task Factory product - the File Gateway Task!
This control flow task will give you the ability to validate your delimited files before performing any downstream actions on that selected file. You can add File level validation rules as well as Row validation rules to ensure a certain level of quality in your delimited files. This component is now available for use for SQL 2012 or higher. Check out a demo of the component in action: