Search Results: derived column

• 
  SSIS Troubleshoot Derived Column Expression Errors

  I have come across several forum posts recently on several different websites asking for help with a problematic Derived Column Expression. When I asked the error being returned, I frequently got: "the expression just turned red" or "I don't know, it isn'

  Author:  Daniel     Date: 6/14/2011     Section: Blog

  tags : Configure Error Output, Derived Column Expression, Expression Error, Troubleshoot, SSIS
• 
  SSIS - Feed new line

  njc78 said: basically I need to replace that little square box with new line, might be derived column/script task? I use a little of both. I have had success declaring a variable and setting it within a script task like this: Imports System Imports System

  Author:  KeithHyer     Date: 7/29/2011     Section: Forum

  tags : carriage return, line break, line feed, SSIS, CR/LF
• 
  Configuring Derived Column transformations

  Last week I looked at how you can configure the Expression property of an SSIS variable ( http://www.bidn.com/blogs/RussLoski/ssas/2688/configuring-variable-expression ). I could build a variable with an expression and then configure the formula that I us

  Author:  RussLoski     Date: 5/7/2012     Section: Blog

  tags : derived column, SSIS Configurations, SSIS Variables
• 
  Derived Column Editor and Column Sizes

  If you look at the metadata on the pipeline between your OLE DB Source and the derived column transform, is the precision and scale correct there? You could also check the advanced editor on the outputs of your source and/or the inputs of your derived col

  Author:  KeithHyer     Date: 11/18/2011     Section: Forum

  tags : datatype, metadata
• 
  SSIS For Each Column in a Data Flow

  When you want to transform data in a data flow task in SSIS, the derived column transform performs this very fast due to the batch method. But if you have hundreds of columns that need the same transform performed on them, it can be very time consuming to

  Author:  MikeDavis     Date: 5/6/2011     Section: Blog

  tags : data flow, derived column, for each column, script trasnform, SSIS
• 
  Setting proper case in SSIS with a Script Task

  The Derived column transform can make a lot of changes in a data flow in SSIS. In about 95% of the time the derived column can take care of any data cleansing issues with text changes. There is one thing that is does not have and that is proper case. The

  Author:  MikeDavis     Date: 1/15/2010     Section: Blog

  tags : C#, Proper Case, Script Transform, VB, SSIS
• 
  Dynamically executinmg the ssis package

  Ok, I think I'm following now. You have 2 options that I can think of off hand ( there are probably more ): Option 1: You could set up a parameter on the package with a default value ( in your date format ) of "{0000}{00}{00}" ( 8 zeros ) - then use a der

  Author:  KeithHyer     Date: 12/18/2011     Section: Forum

  tags : conditional, derived column, inline if
• 
  Check IsNumeric() with Derived Column Transform in SSIS Package

  At some point or another, you've probably run into the road block that is the lack of an ISNUMERIC() equivalent within the SSIS expression language. While you can't use ISNUMERIC() in an SSIS transform, such as a Conditional Split Transform or a Derived C

  Author:  DustinRyan     Date: 7/29/2010     Section: Blog

  tags : SSIS IsNumeric(), IsNumeric check with Derived Column
• 
  Learning to use Derived Columns Transform to convert String data type to “Datetime” type

  In loading “.csv” files to a SQL Server 2008 database, I have encountered several data type issues, especially regarding “Datetime” for a “Modified Date” column on my tables. Here is my ordeal: After adding my Flat File

  Author:  nube07     Date: 3/19/2012     Section: Blog

  tags : atetime, convert, substring
• 
  Convert 24 Hour Time with SSIS Derived Column

  If you want to convert the time part of a DateTime data type into common non-military time display of hour and minute with AM or PM with no leading zeros, you can use this expression in a Derived Column. It uses the DATEPART Function to get the appropriat

  Author:  timmurphy     Date: 8/12/2011     Section: Blog

  tags : derived column, expression, Time
• 
  Sneak Peek: Super Advanced Derived Column Transform In Next Release of Task Factory

  Don't ask how I was able to acquire these screenshots or what favors I may or may not have performed in order to snag these pics of the next release of Task Factory. I'm not proud of what I've become. But the fact of the matter is that Task Factory 3.0 is

  Author:  DustinRyan     Date: 5/31/2012     Section: Blog

  tags : derived column Transform, SSIS expression
• 
  help for text file destination with every row having different column definitin

  Oh good, glad I'm on the right page - that doesn't always happen.. domshar said: Now if you believe that the eg. that you have drafted up above would give me the output as desired would you please describe or paste the pakg derived column transformation,

  Author:  KeithHyer     Date: 6/17/2011     Section: Forum

  tags : multiple formats, text destination, union all, ragged right
• 
  Altering Data with Lookup Transforms

  Today, I finally started the first phase of data migration into Microsoft Dynamics CRM. I had to build a few packages in SSIS to make sure the data was in the proper format. If you read my last post, you remember I was trying to use some derived columns t

  Author:  ShawnHarrison     Date: 1/29/2010     Section: Blog

  tags : fuzzy lookup, SSIS, Lookup transform
• 
  SSIS Expression Help

  tooba said: "NULL"? [COLUMN_B] : [COLUMN_A] ( still red on derived column ) Need help to fix this issue, I want to know where i am wrong. Tooba, I believe you are trying to check if the value is null, then use a or b, depending. You need the expression to

  Author:  m3crast     Date: 3/29/2011     Section: Forum

  tags : case, Derived Column Transformation, if, iif, derived column
• 
  SSIS HELP

  You just need to pay attention if your varchar column has dot "." or comma ",". Here is an example converting varchar to float whereas the varchar column has dot instead of comma: Table I've created with varchar column (notice the dot): Now, in the packag

  Author:  marcoadf     Date: 12/4/2010     Section: Forum

  tags : data conversion, derived column, float, varchar, varchar to float
• 
  Adding expression to Derived Column Transformation

  Bhavika, Are you setting the file to use in the connection manager dynamically? Or are you hard coding it? You should be able to get the file name from your connection manager or if you are doing it dynamically, you can use filename and filepath variables

  Author:  briankmcdonald     Date: 4/12/2011     Section: Forum

  tags : Brian K McDonald, Derived Column, Excel Source, SQLBIGeek, SSIS
• 
  How to set length for a numeric column and datetime in SSIS?

  Are you using Derived Column transform at all? I think, in your case, would help you cleaning up this mess during the process. For a shortcut of cleaning up your data you can try using Task Factory's Data Cleansing Transform . The Task Factory method is q

  Author:  sqlchicken     Date: 8/8/2011     Section: Forum

  tags : etl
• 
  derived column

  Learned something new today... Never used CharIndex in derived column expression before. FindString function replace CharIndex in derived column expression. Syntax : LastName : REPLACE(SUBSTRING(Name,1,FINDSTRING(Name," ",1) - 1),",","") FirstName : SUBST

  Author:  meganathank     Date: 8/30/2012     Section: Forum

  tags : derived column expression, FindString, SSIS expressions
• 
  SSIS, Parallel vs Series Data Flows

  When creating a data flow in SQL Integration Services, it is debatable to place a set of derived columns in a single series path or to use a conditional split to break them up to perform the derived columns only on the rows that need it. So I set up a lit

  Author:  MikeDavis     Date: 11/12/2009     Section: Blog

  tags : SSIS Parallel Series Data Flows
• 
  Fun with Dynamics CRM Part 2: The Derived Column

  So last week, I was having issues with some fields that needed to be migrated from one CRM to another, but where different data types (see previous blog). Since the Scribe Insight formula editor couldn’t handle my monster SELECT CASE statements, I was for

  Author:  ShawnHarrison     Date: 1/25/2010     Section: Blog

  tags : data types, Dynamics CRM, expressions, SSIS, derived column
• 
  How to use a Script Transformation

  Using a Script transformation is a handy way to extend what transforms are available to you. For example, picture social security data that goes into your Script transformation unencrypted and then out encrypted. Typically, you can also use this type of c

  Author:  BrianKnight     Date: 11/7/2009     Section: Blog
• 
  reagarding procedure

  I'm glad it helped. well, to solve that problem, you have 2 options: 1 - use something as CASE WHEN, but in derived column this is done by: MONTH="JANUARY"? 1: MONTH="FEBRUARY"? 2: ... or you make something like this 2 - First transform JANUARY to date ty

  Author:  marcoadf     Date: 6/9/2010     Section: Forum

  tags : derived column, month to int, convert
• 
  Can you ignore blank rows from Excel in SSIS?

  I just did an import from Excel where the last 6,200 rows in the sheet had contained data, but a block was deleted and then the sheet was imported. What imported was the first 2,000 rows of "real" data plus the 6,200 rows of "empty" data. I assume this to

  Author:  KeithHyer     Date: 8/30/2011     Section: Forum

  tags : excel source
• 
  Script transformation giving Object reference not set to an instance when it encounters a blank field from my flat file

  You would not need to overwrite your original file ( though that would be another way to achieve the same goal ). I believe what Mike is suggesting to you it to bring in the "line" ( plain-text containing 150 columns ) as a single column of data and then

  Author:  KeithHyer     Date: 3/8/2012     Section: Forum

  tags : parsing, Replace, string manipulation
• 
  Split column with condition

  I wouldn't use a Conditional Split Transform for this. I'd use a Derived Column. You could use an IIF expression to put the data in the correct column. So your first expression in the Derived Column would look something like this: [ZPENPO] ==1? [ZNILAI]:0

  Author:  DustinRyan     Date: 7/28/2011     Section: Forum