Luis Cazares (7/9/2015)

---

p.shabbir (7/9/2015)

---

You can also define that column as a date in the connection properties for the file and get the error in there.

Either way, you're reading the whole file and validating the column. I hope that this is clear.

Luis,

I tired by changing the datatype as date in the flat file source connection manager and it failed saying data conversion error.

Actually I want to validate the date field in the file before loading the data to staging table. Is there any script (Script task) to valdiate. Based on the validated result from script I will decide whether total file should be rejected or process.

Thanks again.

You're getting an error and you can work around that error using error handlers.

Using a script task is possible, but you'll be reading the file twice instead of once. Why would you want to add the additional step? That's why you're using a staging table.