How to convert blank into null in ssis

sql-server error-handling ssis
Sandeep Pulikonda picture Sandeep Pulikonda · Oct 24, 2012 · Viewed 87.5k times · Source

I am extracting data from excel in ssis. One of the excel column contain blank values. so i need to replace blank value with null otherwise my package is going to fail. Any suggessions?

Answer

Farfarak picture Farfarak · Oct 24, 2012

In DataFlow use DerivedColumn component.

Replace your column and in expression put this line of code

ColumnName == "" ? NULL(DT_WSTR,50) : ColumnName

It will make sure to return null if column is empty

Related questions

How to catch SQLServer timeout exceptions

I need to specifically catch SQL server timeout exceptions so that they can be handled differently. I know I could catch the SqlException and then check if the message string Contains "Timeout" but was wondering if there is a better …

Read More
SQL Server Deadlock Fix: Force join order, or automatically retry?

i have a stored procedure that performs a join of TableB to TableA: SELECT <--- Nested <--- TableA Loop <-- | ---TableB At the same time, in a transaction, rows are inserted into TableA, and then into TableB. …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More