The SSIS GETUTCDATE function is a Date/Time function that returns the current Universal Time Coordinate date and time of the system (UTC time). This article explains how to use the GETUTCDATE function with an example and the syntax for finding the current UTC date and time is shown below.
GETUTCDATE()
To demonstrate the GETUTCDATE function, we use the Employee table below, which has 15 records. Please refer to the Union All Transformation, Derived Column Transformation, Built-in Functions, and SQL Server articles in SSIS.
SSIS GETUTCDATE function
For this GETUTCDATE example, add a Data Flow Task and double-click on it to enter the Data Flow region. Next, add the OLE DB Source to read data from the above SQL database table. Please join the OLE DB Source to Derived Column Transformation to write GETUTCDATE expressions and create new columns.
Next, double-click on it to open the Derived Column Transformation Editor. Drop the SSIS GETUTCDATE function to the row under the Expression to return the current UTC or GMT date and time according to the system.
GETUTCDATE()
Click OK to close the Editor window.
Drag and drop the Union All Transformation and connect the Derived Column. Next, right-click on the connection node and choose the Enable Data Viewer. Please run the GETUTCDATE function package to see the current date and time in UTC time.
