I'm tryin to insert some records from table1 to table2 using ssis. table1 has column1 which may contain some empty strings or padded with spaces, how do I transform those empty strings to nulls when I'm inserting into table 2.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…