Yes It will convert it to 0. But I had the same issue and I used derive column with above expression and converted empty space into NULL and then I use Data Conversion Task. That will convert string to int.
"CampaignID","CampaignName","BrandID","CreationDate","StartDate","EndDate","SegmentationType","DefaultTargetAudience","MasterCampaignID"
"115323","F'11 Chunky CBI/CHU/10","16171","7/22/2010 1:07:05 PM","1/1/2010 12:00:00 AM","9/30/2011 11:59:00 PM"," "," "," "
This above is my data that i was working on. And I process " " as Null.
Thanks:-)
Viresh
--------------------------------------------------------------------------
“ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
— Sir Henri Deterding