Post reply

How to add field value through SSIS variable to another table

  • September 4, 2010 at 2:34 pm

    #239940

    I have a Files table . I want to grab the FileID from that table in the staging table respective to the file processed . This task should be through SSIS .

    FName LName FileID

    Lorena Baylor 1

    Gayatri KKK 1

    Lopa Das 2

    The first two records are from the same file hence same fileID . The third column FileId is from the files table and the FName and LName is from an excel source

  • September 6, 2010 at 4:29 am

    #1216835

    And how do you know which FileID you need from the Files table?

    Do you want to perform a lookup using the Fname and Lname columns?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 7, 2010 at 6:18 am

    #1217262

    Are you presenting the data at start or the desired end state? If the latter, is the file ID part of the file name? Please provide more details.

  • September 7, 2010 at 7:43 am

    #1217335

    I have the data from an excel sheet . FileId is not a part of the data . I use the filename and store it into another files table with file id as the primary key(auto increment).

    Then I want to add this fileID in the source and add it to the destination SQL Server table .

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

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