Post reply

importing excel file to a table with ssis with 2 extra fields come from variable

  • December 21, 2009 at 9:15 am

    #136866

    Hello All,

    I am new to SSIS. I wonder if I can get some help on this task: I am importing excel file to a table. There 2 fields that I would use 2 of the varialbles that I create and pass in from the calling stored procedure. I don't know how to assign the variables to the fields in the table. Please help.. thanks in a dvance.

    Sherry

  • December 21, 2009 at 9:16 am

    #1094841

    In the Data Flow task, you can add Derived Columns to the source definition. That'll do what you need.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • December 23, 2009 at 7:08 am

    #1095898

    it works. thank you... 🙂

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

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