Average: 5 (2 votes)


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.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus

ScriptMain