Im using SSIS to create a flat file retrieving data from a table. Im using Visual Basic 2008 and SQL server 2008.
I have a Data flow Task inside which i have a OLE DB Source component which retrieves data from a table and sends it to a script component. One of the field that is retrieved from the table is a DateOfBirth Field. It is of datatype "date". When i use IsDBNull(DateOfBirth) in the Script component im getting a "RunTime Error: The column has a null value.".
Why is this happening? Is this a bug in SSIS?