ssis issues

  • Source is a flat file. I want to load the data of the flat file into the target along with the file name. For example, the source is products data which is shown below:

    source data:

    columname:cat products.dat

    Chocolate

    Biscuit

    The target should contain the below data:

    Code:

    product, filename

    ------------------------

    Chocolate, products.dat

    Biscuit, products.dat

    how we achie this issuse in ssis plz tell me

  • Store the filename in a variable and append the value in a new column to your pipeline using the Derived Column Transformation.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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