Hi all,

I resolved the issue by doing a additional check in my stored proc, checking to see if a certain value <> ''

The value should never be empty as it is a required field or it can't be inserted anyway.since the supplier file only has 3-5 rows a day there isn't any performance issue so the process is fine.

However in saying that I am still interested if there is a way to perform this through the SSIS package -