DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Overview
Data flow source, providing separate date elements.
Setup
The script has the following parameters:
- IterationStep - specifies date sequence iteration step in days.
- Culture - selects date culture.
- IsStartDateVariable - indicates whether the start date is stored in a variable.
-
- StartDate - specifies start date.
-
- StartDateVariable - selects variable containing start date.
- IsEndDateVariable - indicates whether the end date is stored in a variable.
-
- endDate - specifies end date.
-
- EndDateVariable - selects variable containing end date.
Output columns provided by the script.
- Day - day of the month.
- DayShortName - day of week text (short).
- DayName - day of week text.
- DayOfYear - day of year.
- Week - week of year.
- Month - month.
- MonthShortName - month text (short).
- MonthName - month text.
- Quarter - quarter (Q1, Q2, Q3, Q4).
- Year - year.
Requirements
Depends on COZYROC Script Component Plus component for implementing parameters user interface.