Post reply

SSIS SCENARIO

  • February 1, 2012 at 12:48 am

    #254600

    Hi all,

    I am using the Sql server2008. I have one Problem

    i want to read the data in excel and dump into the table

    if any update happen i have to compare and load new data

    Problem is

    To read the data in Xcel file i have to choose the option below in OLDB CONN Manager

    Native OLE DB\Microsoft Office 12.0 Access Database Engine OLE DB Provider from the OLE DB Provider list.

    But in ssis 2008 i dont have the above option

    Can anyone help on this.....

  • February 1, 2012 at 1:06 am

    #1441063

    You have to go through a couple of hoops to hook SSIS to the new office documents (2k7+).

    This walkthrough is a good place to get started:

    http://dataintegrity.wordpress.com/2009/10/16/xlsx/

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • February 1, 2012 at 3:48 am

    #1441115

    Hi

    I Read that details present in the link which u sent

    but the problem is in that article they said to choose the Microsoft Office 12.0 Access Database Engine OLE DB Provider. but this option is not found in 2008 version

  • February 1, 2012 at 5:16 am

    #1441141

    You don't have the option to choose Excel 2007?

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

  • February 1, 2012 at 6:52 am

    #1441194

    :w00t:

    Hello ,Why not found ,If you install excel 2007 ,You will found automatically

    thanks

  • February 1, 2012 at 10:34 am

    #1441330

    johnitech.itech (2/1/2012)

    :w00t:

    Hello ,Why not found ,If you install excel 2007 ,You will found automatically

    thanks

    That's incorrect. You need to install Excel 2k7 or 2012, then still perform those tasks. They aren't automatically picked up. You'll also need to run in 32 bit mode, as there aren't 64 bit drivers for that interface yet.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 6 posts - 1 through 5 (of 5 total)

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