Stack Overflow
Stack Overflow

Questions tagged [derived-column]

SSIS Derived Column Transformation is one of the SQL Server Integration Services that can be added within a Data Flow Task, it is used to add a new column to the data pipeline by applying SSIS expressions. The developer can choose whether to add a new derived column or to replace an existing column.

SSIS Derived Column Transformation is one of the SQL Server Integration Services that can be added within a Data Flow Task, it is used to add a new column to the data pipeline by applying SSIS expressions. The developer can choose whether to add a new derived column or to replace an existing column.

SSIS expressions are a combination of literals, functions, operators that yields a single data value. An expression can be composed of a single value (“abc”) or a variable (@[User::Variable1]) or a function (GETDATE()), or it can be more complex and contains some conditionals (CASE statement) or some mathematical operations or some string manipulation.

References

164 questions
1
vote
2 answers

Replace function in SSIS

There are 3 column in my Sender Master table, First_Name, Middle_Name,Last_Name. Whenever I am loading data from a csv file, Last name gets filled in Middle name. I am trying to Replace Last_Name with middle using Derived Expression but getting…
Vishal Mishr
  • 195
  • 1
  • 8
1
vote
2 answers

SSIS Flat File add trailing spaces to columns

I am developing a SSIS package which concatenates 3 columns and then outputs the result to a flat file. 1st column is a emp_number consists of length 10. The values which I get is "12345" or "123456" or "1234567". In the output I want is "12345 …
user1526892
  • 61
  • 8
1
vote
1 answer

The data types "DT_WSTR" and "DT_I4" are incompatible for binary operator "=="

I am using the following expression: [TIMEPERIOD_ID]==1?"JANUARY": [TIMEPERIOD_ID]==2?"FEBRUARY": [TIMEPERIOD_ID]==3?"MARCH":…
Tirtha Roy Chowdhury
  • 77
  • 1
  • 7
1
vote
2 answers

Import from XML drops leading 0

I have an SSIS package that imports an XML file into SQL. The data of one particular field could be '112' or '039', for example. It is always three characters and gets padded with a leading 0 if only two. The Destination field in SQL is varchar. For…
opperman.eric
  • 314
  • 1
  • 14
1
vote
1 answer

Selecting Row(s) Based Upon Derived Value Maximum

I need to display the most followed individuals in a group of people. SELECT * FROM User JOIN( SELECT DISTINCT f.followee_id, COUNT(*) as cnt FROM Follow f GROUP BY f.followee_id ORDER BY cnt desc) derv_table WHERE User.id =…
Lost Modernity
  • 25
  • 3
1
vote
2 answers

SSIS derived Column (DateKey)

I am trying to create a derived column that will convert the date into a date keys, apparently, I got the expression right but when I run the package and go to my destination table I don't see my derived column created. I am not sure what could be…
Rachel
  • 208
  • 1
  • 5
  • 18
1
vote
2 answers

SSIS Derived Column error on expression

I have a SSIS package, where I have four different data flow task. Each data flow task (say, A, B, C, D) has same derived column expression and appends the results from different oledb source to the same oledb destination. I get an error as below…
katy89
  • 161
  • 2
  • 13
1
vote
2 answers

Create a variable from SSIS Derived Column

In my SSIS package, I have a Script Component that creates a +1 new customer ID when the package runs. I want to assign the numerical value of the ID to a variable. The variable will be used in a File System Task to create a directory with the…
David F
  • 265
  • 2
  • 14
1
vote
1 answer

SSIS Foreach loop error on CSV files

Right, so I have a foreach loop with a data flow inside going through a group of files with all the exact same format. This changes a few things with a derived column which is all getting dumped into a SQL Server Database which will become my…
Arthur Verrept
  • 45
  • 1
  • 7
1
vote
1 answer

SSIS-convert IF and ELSE statement or Case When statement in SSIS derived column expression

SSIS-convert IF and ELSE statement or Case When statement in SSIS derived column expression. An assumption here is, User exist in both system in SAP and Salesforce the email for that user would be same and we can populate any emailid but if the user…
Lopamudra Sahoo
  • 13
  • 1
  • 3
1
vote
1 answer

Data type mismatch in derived column SSIS 2010

I am trying to check data on the products table which has a column of discontinued item i.e. 1 is true and 0 is false. I am using a derived column to output the result in the staging table to YES for 1 or NO for 0. However, when it comes to linking…
Dodi
  • 111
  • 4
  • 14
1
vote
1 answer

Change date format of data coming from flat file SSIS

I am reading data from a flat file and storing them in a OLE DB destination. In the flat file, dates and in various formats 17/02/2014, 28-Apr-14, 30.06.14 I have used a Derived column transformation to check for empty columns and replace it with…
BRDroid
  • 3,920
  • 8
  • 65
  • 143
1
vote
2 answers

SSIS Derived Column - Text in Numeric Field is not converting

I'm importing thousands of csv files into an SQL DB. They each have two columns: Date and Value. In some of the files, the value column contains simply a period (ex: "."). I've tried to create a derived column that will handle any cell that…
putty
  • 744
  • 1
  • 6
  • 14
1
vote
1 answer

Create New Columns from a DateTime Column

This is my SSIS excerise I have a DATETIME column, what I want is to get the Month and Year from " DATETIME " column and load it into a new column called “Month_Year” and then get day from the same " DATETIME " and load it into a new column called…
user175767
0
votes
1 answer

ADF: Derived column with multiple (true) conditions returning string array

I have the following problem in a Data Factory data flow: I have two pipelines that extract data: one daily on weekdays, and one monthly on the first working day of each month. In the data flow I would like to insert a derived column, 'Frequency',…
fabio.sitzia
  • 3
  • 3
1 2 3
…
10 11