Post reply

Initialize variable through SQL statement

  • September 8, 2010 at 3:12 pm

    #146837

    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

    How to grab this info in a variable through a sql statement ?

  • September 8, 2010 at 3:33 pm

    #1218285

    Take a look at this: http://www.sqlis.com/post/The-Execute-SQL-Task.aspx


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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