I'm new to SSIS and tryint to create my first package. I have a source file that I'm reading in as text b/c the data is inconsistent (ex., a null date value is represented by zero). I need to do some transformation, such as check a date value is equal to zero, etc. I found the script transformation task but it seems like overkill. Is there any easy way to do this?