Search Results: for each column

• 
  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
• 
  SSIS 2008 For Each Column in a Data flow

  Previously I wrote a blog on how to do a for each loop to look through each col in an SSIS data flow here . Well things have changed since I wrote that blog, in fact I believe that old  code only works in SSIS 2005. So I thought I would be good to up

  Author:  MikeDavis     Date: 9/29/2011     Section: Blog
• 
  delay validation property for oledb destination?

  I have a simple package where i import a text file into a table. The text file sometimes has spaces before and after the data for each column, so i have a derived column transformation between the flat file source and oledb destination where I do an RTRIM

  Author:  sherz1000     Date: 3/18/2010     Section: Forum
• 
  Script transformation giving Object reference not set to an instance when it encounters a blank field from my flat file

  Hi all, I am importing a flat file to SQL, and have 150 columns that contain fields with either '-' or '.' characters that I need to strip out. The issue I'm facing is that of these 150 columns, some are blank, i.e. my .csv source file goes txt,bob,123,,,

  Author:  user161716     Date: 3/1/2012     Section: Forum

  tags : script-transformation
• 
  Previous Month Data and Current Month Data

  Hi, My requirement is : When Dashboard page loads by default i need to display Current Snapshot Value and for each column in KPI has a trend to compare the current snapshot value with Previous snapshot data. In my scenario, my Fact table will have n numbe

  Author:  marksmiley     Date: 8/16/2011     Section: Forum
• 
  SCD Help

  If you're using the native SCD wizard, it sounds like what you need to do is go back and set the Change Type for each column you think will be changing (e.g. ID) and change it from a fixed attribute to a changing one. Once you do this, the wizard knows th

  Author:  sqlchicken     Date: 5/6/2011     Section: Forum
• 
  Variables and Expressions in SSIS

  One of the great things about SSIS (SQL Server Integration Services) is the ability to make just about any property dynamic. You can set up variables which can be controlled through configurations or, if you are using SSIS 2012, through Parameters. The va

  Author:  KathiKellenberger     Date: 11/28/2012     Section: Blog
• 
  Find Current Snapshot and Previous Snapshot Value using MDX Query

  Hi Anil, Thanks for d post. Lead and Log funcitons are also not working actually. Let me explain u the exact requirement My requirement is : When Dashboard page loads by default i need to display Current Snapshot Value and for each column in Score card ha

  Author:  marksmiley     Date: 8/16/2011     Section: Forum