How to change only Date value in DATE TIME datatype in SSIS

Question

Post reply

How to change only Date value in DATE TIME datatype in SSIS

subratnayak09

SSC Eights!

Points: 820
More actions
June 19, 2017 at 1:06 pm

#322183

I need to change date field to default 01 in DATE TIME data type holding same month value.
current value 05/29/2016 - 05/01/2016
current value 06/19/2017 - 06/01/2017

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

Try something like this

DATEADD( "d", -1 * DATEPART( "d", GETDATE() )+1 , GETDATE() )

Replace GETDATE() with your variable name.

subratnayak09 SSC Eights! Points: 820 More actions · Answer 2

Data is coming from flat file so I can't use Sql functions.Please suggest on Derived expression or Script task

Phil Parkin SSC Guru Points: 247180 More actions · Answer 3

subratnayak09 - Monday, June 19, 2017 1:28 PM
Data is coming from flat file so I can't use Sql functions.Please suggest on Derived expression or Script task

Please check again. Those are SSIS functions. They will work in a derived column transformation.

subratnayak09 SSC Eights! Points: 820 More actions · Answer 4

Provided solution working fine . Thanks a lot for your help.