Don't repeat yourself. I created the IO Kit for SSIS because I found myself performing the same ETL tasks over and over again. These tutorials will show you recipes for common file processing scenarios. No coding necessary. Make your ETL more robust in less time!

Save a file to a database.

You need to load a file on a drive or network share into a database. With this solution, make quick work of saving files to a database. Conversion to Base 64 format is automatic. This solution works with all popular file formats such as Word, PDF, PNG, and TIFF.


Conditional processing by file type.

You need to process multiple files in a directory but they are not all the same file type. Learn how to easily determine the file type of any file and route it to the appropriate task.


Process a large number of files in batches.

You have a large number of files in a directory and you want to process them in batches. Watch this video to see how you can do this with practically no effort at all.


Find the most recent file.

You have multiple similar files but you only want to process the most recent file. This can improve the quality of your data and save you from processing files unnecessarily. See how to quickly achieve this trick with no coding.


Check if a file exists.

You need to check if a file exists before running your ETL. That's easily done and we'll explain how in this tutorial.


Create a filename dynamically.

You need to create a filename dynamically because you want the timestamp to appear in the filename. This way, your B2B partner will know exactly when the file was created and in what order to process it. This solution lets you do just that with a simple syntax that's easy to learn.