SSIS Expression

Question

Hi,

I have the expression task form SSIS and needs to check to see if today's date is the end of the current month.

compare between current date is the last date of the month, but I am not sure how to put all together as the expression

convert(date,DATEADD("d", -DAY(GETDATE()), DATEADD("m", 1, GETDATE()))) =convert(date, getdate())

Thanks

Answer 1

Hi @Vicki ,

We can use the following expression in SSIS Expression Task to check if current day is the last day of current month:

1. If it is, the result will be True.
2. If it isn't, the result will be False.

(DT_WSTR, 50)(DT_DBDATE)GETDATE() == (DT_WSTR, 50)(DT_DBDATE)DATEADD("d", -DAY(GETDATE()), DATEADD("m", 1, GETDATE()))

Please refer to the following pictures:

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?