June 19, 2017 at 1:06 pm
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
June 19, 2017 at 1:22 pm
Try something like this
DATEADD( "d", -1 * DATEPART( "d", GETDATE() )+1 , GETDATE() )
Replace GETDATE() with your variable name.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 19, 2017 at 1:28 pm
Data is coming from flat file so I can't use Sql functions.Please suggest on Derived expression or Script task
June 19, 2017 at 1:34 pm
subratnayak09 - Monday, June 19, 2017 1:28 PMData 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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 20, 2017 at 2:34 am
Provided solution working fine . Thanks a lot for your help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply