Create a New Row in SSIS Data Flow

• Gabriel P

  SSCarpal Tunnel

  Points: 4289

  More actions

  January 21, 2013 at 8:50 am

  #273061

  Hello,

  Does anyone know if it's possible to create a row in an SSIS Data Flow? My original thought was just to create an OLE DB Source with a query like "SELECT 1 As RowNum" but connecting to a database just to create a fake row doesn't feel like good design. Ultimately I want to use this row to attach to a Derived Column transformation in order to append ssis variables as columns to this one row.

  I realize this can probably be done more elegantly with a Script Component, but that is a last resort as I am the only one on my team who knows .Net...and I don't want to be the only one supporting this package 🙂

• Phil Parkin

  SSC Guru

  Points: 246991

  More actions

  January 21, 2013 at 11:49 am

  #1579341

  What's your data source?

  If it's an RDBMS of some sort, you could always change it to a query containing a UNION:

  select [good stuff]

  union

  select [vapour stuff]

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel