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
0
votes
0 answers

Derived column expression with -1

I am trying to figure out what a developer did when he setup a derived column in a SSIS package, He is looking up customer ID to insert to a table and has set the Expression value to "-1" Why -1?
Bahman
  • 1
0
votes
2 answers

How can I turn a string into a decimal in SSIS using a derived column?

I am working in SSIS to fill a staging area database. I want to transfer the following data: ------------------------------------------------------------------- | ShipName (String) | MaxContainers (int) | FuelCapacity (String)…
MissionarisMalleman
  • 13
  • 2
0
votes
1 answer

Need SSIS Expression help for find keyword in filename

I need help for below scenario. I have file names like this abc_assessment_20200303121212.csv fgcdv_assessment_20200303121212.csv xycv_assessment_20200303121212.csv Now I need to right expression into SSIS package to identify files which contains…
user2795318
  • 33
  • 5
0
votes
1 answer

Hive (hql) for derived columns and find the total

Could you please guide I have a scenario where credit_Date,debit_date and loan_date can have different values of date or same. Output table have below columns Date: should combine credit_date, debit_date and loan_date ( credit_date, debit_date and…
smp97
  • 63
  • 6
0
votes
1 answer

Hive query for derived columns and find the total of derived column

I have a scenario where credit_Date, debit_date and loan_date can be same. Output table have below columns Date: should combine credit_date, debit_date and loan_date ( credit_date, debit_date and loan_date can be same (or) null) Credit_payment: Find…
smp97
  • 63
  • 6
0
votes
1 answer

hive query for derived columns

Could you please guide. Input table (Table1) have columns like credit_date, credit_amount, debit_date, debit_amount, loan_date, loan_amount. Output table(Table 2) have columns like date, credit_payment, Debit_payment, Loan_payment. Date : should…
smp97
  • 63
  • 6
0
votes
1 answer

How to load the values of three column from one table1 to another table 2 which is having single column in hive?

Could you please help me below query. Table 1 (Input)had three columns (Credit_date, Debit_date, Payment_date) and Table 2 (Output) has one column date The three column values from Table 1 should be available in Table 2. I tried below query but not…
smp97
  • 63
  • 6
0
votes
2 answers

SSIS Derived Column Transformation if not blank

i have added a Derived Column task that adds " at the beginning of a field and " at the end of a field but i only want to apply it if the field is not null/not blank and contains characters my expression is, this works and correctly ads "" to the…
sql2015
  • 591
  • 3
  • 13
  • 34
0
votes
3 answers

How to check date format in Azure Data Factory

I am creating a pipeline where the source is csv files and sink is SQL Server. The date column in CSV file may have values like 12/31/2020 10162018 20201017 31/12/1982 1982/12/31 I do not find the function which checks the format of the date. How…
Abhishek Vyas
  • 599
  • 1
  • 9
  • 24
0
votes
0 answers

Computed column in POSTGRESQL-Column Derived from a function

Want to create a COMPUTED COLUMN in POSTGRESQL which has to be a migration of MSSQLCODE .The computed column is as a result of a function "FUN_GetExternalSystemNameFull" MSSQL CODE FOR TABLE CREATE TABLE ClientApplication( ClientApplicationId…
dn2301
  • 5
  • 4
0
votes
0 answers

How to insert hash value to azure sql database from azure data factory data flow

I have a sql DB which stores hash value in the column of binary data type. I use sql hashbytes of shah256 algorithm in my sql stored procedure to find hash value and store in the db. I want to replicate the same in Azure data factory. I'm seeing…
javababy
  • 17
  • 10
0
votes
3 answers

Converting Month Number(Date Time or 4 byte integer) to Month Name(String) SSIS

I need to convert month number to month name. I have date time as the date type - 2009-01-01 00:00:00.000 I also have 4-byte integer data type - 1 how do I convert this 1 to "January" for example?
user13739771
  • 21
  • 4
0
votes
2 answers

Can I use a derived column in SQL Server for performing a CASE function?

I have a 'main' table, C1, which has a record identifier, which in turn may be linked to either an account or a customer ID. The relationship / linkage is stored on two separate tables, one with record ID - Account level relationship, and the other…
SQLGIT_GeekInTraining
  • 133
  • 1
  • 11
0
votes
0 answers

create a new Column with value derived from original column

The question is how to add a new column with derived value. I have the following table named Character Name PointsTotal Kat 310 Mat 410 Sam 550 Ram 660 I want the result to display the new column name Level which is…
Ravin Lamichhane
  • 1
0
votes
2 answers

Convert DDMMYY to DD-MM-YY in SSIS Derived Column

I am facing issue while placing "-" in a varchar datatype. . Need is after last two digits we need to put "-" and then again after two digits and so on. Input String is- 21220 Output String- 2-12-20 Or, Input String- 311220 Output String-…
Bibhudatta Hotta
  • 1
  • 1
1 2 3
…
10 11