SSIS Conditional Split Transformation

You may have a big file or a large database table that you want to split up into different csv files.  Instead of writing multiple queries for the different cases, you can use  Conditional Split within SSIS to accomplish this task.  There are also a multitude of other scenarios you can use it for.

Continue reading SSIS Conditional Split Transformation

SSIS ORA-00900: invalid SQL statement calling Oracle Procedure

Calling an Oracle stored procedure in SSIS is a little different than calling a SQL Server version.  Today I will show you the error you get if trying the SQL Server syntax and how to fix it.

Continue reading SSIS ORA-00900: invalid SQL statement calling Oracle Procedure

Load multiple files with SSIS Foreach Loop Container

You just finished your SSIS project where you needed to load a CSV file into a Sql Server database table, but now you just found out that multiple files with the same data will now need to be loaded.  Using the Foreach Loop Container in SSIS makes this relatively easy.

Continue reading Load multiple files with SSIS Foreach Loop Container

SSIS: Cannot convert between unicode and non-unicode string data types during import

Here is an issue you may receive if you try to import data from an Excel spreadsheet into a Sql Server database table:

 

Error at Data Flow Task [OLE DB Destination [23]]: Columns “firstname” and “FirstName” cannot convert between unicode and non-unicode string data types.

Continue reading SSIS: Cannot convert between unicode and non-unicode string data types during import