Excel file to SQL server

  • Hi,

    I am a newbie to SSIS. I have SSIS installed on the server.

    I want to import the data from excel file to the sql server database and create a new table out of the data.

    Is it possible thru SSIS.??

    If yes, then how?

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • Honestly, I'd hit the SSIS tutorials online to get oriented to building SSIS packages, if I were you. I could outline the process, but it won't be as easy to follow as the tutorials.

    - 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

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

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