data file blanks to nulls

Hi,

With DTS, the default behavior is to import blanks ("") in a data file as nulls in the table.

However, in SSIS, the default behavior is to import blanks as blanks.

I need to ensure that the packages I'm migrating import the data in the exact same way. I am wondering what is the easiest way to convert blanks to nulls

Right now I'm using a script to convert the blanks to nulls before they are written to the table, but just wondering if there's an easier way.

Thanks

Hi,

Do you have an example of how to process the columns generically I'm not sure how I would do this, but that would be helpful!

Thanks

Thanks

I

Thanks

I supposed I

Thanks

I suppose

Thanks

I suppose could set this up to

Thanks

I suppose could set this up to process

Thanks

I suppose could set this up to process numerics in s

Thanks

I suppose could set this up to process numerics in a

Thanks

I suppose could set this up to process numerics in a separate s

Thanks

I suppose could set this up to process numerics in a separate script

Thanks

I suppose could set this up to process numerics in a separate script (only