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
1 answer

Pandas derived column for number of work days between 2 dates

The numpy busdays_count works but when I apply it to the dataframe I get errors because some of the dates are NaT (correctly). If it was a normal array I could iterate each row, check if NaT and then apply the formulae but not sure here…
Dean
  • 1
  • 1
  • 3
0
votes
1 answer

How to lookup data coming from two different datasets with SSIS

I have two CSV files extracted from an operationnal database. One CSV is listing ProductsID that have been sold and the product category Name in a foreign language The second CSV has two columns, one with the full list of product category Name…
FeniceFenice
  • 3
  • 2
0
votes
1 answer

Kingswaysoft record update: Is there a way to add a variable that increases eacht time with +1

What I have is productname: playstation productname: xbox What I want is: productname: product 1 productname: product 2 I'm using a derrived column to achieve this but can't find a way to add a variable that increases each time with +1 Is there a…
Selim
  • 1
0
votes
1 answer

Filtering date column in Visual Studio SSIS ( Derived column)

I want to filter a column that spans from 2014-2019 to 2017-2018 in VS with SSIS. I have tried different things but none seem to work.
MathieuAPLep
  • 11
  • 2
0
votes
0 answers

Can't make SSIS regex (regular expression) work (Premium derived column component from kingswaysoft)

I'm using SSIS Productivity Pack and have encountered an issue with Premium derived column component on regex function: RegexFindMatch( [my_column], [^\s]+(?="$), 1) [I need to get smth3 from string smth1, smth2, smth3. or smth2, smth3. or , smth3…
Ewa
  • 53
  • 1
  • 6
0
votes
1 answer

Calculate next wednesday based on any given date using ssis derived column expression

I am creating a package which will store a report's generation date. on basis of that date need to derive the next Wwednesday date. Ex: report date is 11/11/2019 so wed date should be 13/11/2019.
user12391095
0
votes
0 answers

How can I change dates formated as MM-DD-YYYY to have no leading zeroes in MM and DD in SSIS?

I am loading a flat file to a database table, and with prior help with SSIS Derived Column task, I was able to convert the date of data type STRING from YYYY-MM-DD in the flat file to MM/DD/YYYY in the database table. However, I notice that it…
Sast77
  • 97
  • 1
  • 9
0
votes
1 answer

SSIS derived column not updating into database

I have an SSIS package that takes data from a csv file goes through a data conversion to convert data type then imports into a database. I wanted to remove part of a string from a column before importing it into the database so I included a derived…
sql2015
  • 591
  • 3
  • 13
  • 34
0
votes
1 answer

Can derived columns in ADF Dataflow be used to map without creating duplicate columns?

I'm trying to change column names using derived columns. I'm able to do this with one mapping per column but after that I get a 'Duplicate Column' problem. Can this be done with derived columns? Thanks!
Noxville
  • 53
  • 2
  • 4
0
votes
1 answer

insert computed data in table in laravel

I need to store interest_amount which is computed using get_Attribute function however now I need to insert it into table. I have used static::saving function to compute interest_amount I don't know how to call it using $data in…
Prithvi Tuladhar
  • 73
  • 10
0
votes
0 answers

Derive column does not substring desired columns from row input

My question is about using "Derived Column Transformation". Situation: A row already retrieved from flat file successfully. I am trying to derive multiple columns by using "Derived Column" and substring function. There are as many as 36 columns that…
Binoy
  • 390
  • 5
  • 19
0
votes
1 answer

SSIS derived column error (cast type)

I am trying to sum 2 columns (adjustment due day and expiration day): DATEADD("dd",(DT_I4)AdjustmentDueDayCode,ExpirationDate) I keep getting the following error message: An error occurred while attempting to perform a type cast SSIS Error Code…
Rachel
  • 208
  • 1
  • 5
  • 18
0
votes
1 answer

SSIS DTS_E_INDUCEDTRANSFORMFAILUREONERROR

I am getting the following error message for my SSIS package: Error: 0xC0049063 at Data Flow Task, Calculate Percentage Change [34]: The conditional operation failed. Error: 0xC0209029 at Data Flow Task, Calculate Percentage Change [34]: SSIS Error…
Rachel
  • 208
  • 1
  • 5
  • 18
0
votes
3 answers

Creating derived columns from column of variable length components

I'm hoping to get your guidance on this. I have a column, consisting of variable length sections that needs to be split into separate additional columns. The column, PCMRetrievalCode is nvarchar type and consists of this format: i.e.…
daniness
  • 363
  • 1
  • 4
  • 21
0
votes
1 answer

divide by zero error (SSIS)

Within SSIS I am trying to do a simple division: TotalIncurredAmount / TotalPremiumAmount` So I wrote the following expression in an SSIS Derived Column transformation: TotalIncurredAmount / (ISNULL(TotalPremiumAmount) ? 1 :…
Rachel
  • 208
  • 1
  • 5
  • 18
1 2 3
…
10 11