Thank You for your response. I will try to implement what you suggested about getting date using derived column in dataflow task.

As far as your question about...