SSIS: Importing an Excel file using conditional split & exporting results into multiple textfiles

This tutorial will demonstrate how to use SSIS for an Excel file import & then based on several case conditions splitting the results by exporting them to multiple textfiles.


Hope you enjoy it! Please leave feedback if this was helpful. Thanks!

SSIS: Importing a CSV file into a SQL Server and possible related issues due to mismatching datatypes

This video will demonstrate how to import a CSV file into a SQL Server database table. No matter if Excel sheet or CSV file, it is very likely that you will face some datatype conflicts due to different source file and destination defined datatypes. This video should explain how to solve common import issues.

Hope you enjoy it! Please leave feedback if this was helpful. Thanks!