Yup, you nailed it hunchback .... the previous sheets I got did not have any nulls and I forgot that....just found out they only need this task to be done once a week for 2 sheets & I have to modify a few things in Excel to make it "SSIS friendly" so might just cheat with a dummy value that I know could never be used unless this becomes a bigger "project" and I have to do this 5 minute task often. Cheers all.

-Dave