Post reply

How to Load data which has reccuring reqirement to SQL Server 2005?

  • January 6, 2010 at 8:00 pm

    #215374

    Hello,

    I am a newbie to SQL Server and I am trying to load data (which is in Excel) to SQL Server. So, what will be best way to load this data since it is a recurring requirement?

    Suggestions will be appreciated.

    Thanks

  • January 7, 2010 at 4:52 am

    #1100118

    So, what will be best way to load this data since it is a recurring requirement?

    It depends...

    Will the file always have the same name and being located in the same folder? If so, I'd use a linked server.

    If the file has the same "base name" with varying, but predictable part (e.g. myExcel20100107.xls for today), I'd use Openrowset.

    If the file is in the same folder but always a different name I'd probably use SSIS.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • January 7, 2010 at 6:26 am

    #1100144

    I second Lutz thoughts, you can use any one of the ideas. I personally would incline towards SSIS since it gives more capabilities and tools to do this, considering a file name is expected, you can change the SSIS package still to do it for you.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • January 14, 2010 at 7:25 pm

    #1104032

    You can right click on your database and choose tasks -> Import Data.

    Then you can walk through the import wizard and on one of the last screens there will be a checkbox where you can choose to keep the SSIS package (so you can run it again later).

    Chris

    http://chrisbarba.wordpress.com

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

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