Post reply

Add a new column in addition to file in Data Flow or somewhere else?

  • May 19, 2011 at 8:50 am

    #236577

    I am importing csv files into a table, I need to add a column MachineNr into the data flow before the data is passed to the table. I want the field MachineNr = 'C935175' also. Do I do this in the Data Flow tab using Script Component or is there a faster, easier, different way to do it?

    The reason I don't want to do it with a script task in the Control Flow tab after the data is imported to the table is it's not as simple as 'if the field MachineNr is null update to C935175' because other files from other machines could be adding data at the same time.

    Thanks!

  • May 19, 2011 at 8:56 am

    #1327141

    You can use the Derived Column transformation.

    John

  • May 19, 2011 at 10:18 am

    #1327209

    That worked perfect, easy and simple.

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply