My Rational Rights

calculating how many days remaining in a month or last day of month or any other scenarios: declare @numberOfDaysInMonth int; set @numberOfDaysInMonth = DAY(DATEADD (m, 1, DATEADD (d, 1 - DAY(getdate()), getdate())) - 1);

1. Right click in the control flow and add the configuratin and click next, next -> finish. 2. Pass words will not be added in the configuration file, We have to add in the two places( a. connection string and password property