Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Msg 7399, Level 16, State 1 Linked Server. Access Denied January 5, 2021
  • Another feature I wish SQL Server had. December 3, 2020
  • Msg 8115, Level 16 Arithmetic overflow November 4, 2020
  • SQL Server Columnstore Index Performance Benefits October 6, 2020
  • SQL Server: Login Failed for user Error: 18456 September 4, 2020
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Dec    

Tag: Derived Column

SSIS Derived Column Transformation

When you create an ETL process, sometimes the source data is not in the format that you need to load into the database.  Below is an example of using a derived column to format the data so it fits into the database the way you require.

Continue reading SSIS Derived Column Transformation

Posted on November 12, 2019September 14, 2019Categories Hints and TipsTags Derived Column, ssisLeave a comment on SSIS Derived Column Transformation
Create a website or blog at WordPress.com