Post reply

data load from excel 2007 source to excel 2007 destination

  • November 20, 2008 at 9:13 am

    #127073

    Hi Gurus,

    i am using SQL Server 2005 Integration Services(SSIS) to extract and load data into datawarehouse.Here my source is Excel 2007 and destination also Excel 2007.how i can do this.tell me in briefly

    thanks

    murali

  • November 20, 2008 at 9:19 am

    #901116

    You will need to use Execel Source in Data Flow Source & Excel Destination in

    Data Flow Destination.These are available in the Toolbox.

  • November 20, 2008 at 9:55 am

    #901160

    I am not sure if the Excel source will work fine for Excel 2007. It surely worked well with Excel 2003, but when I tried using it with Excel 2007. Still you can try and if the Excel source does not work, then you can reply to this post and I will tell you how can you connect to Excel 2007 using OLE DB Source.

    Good Luck.

  • November 20, 2008 at 10:06 am

    #901170

    Hi

    Excel Source and Excel destinations dont work for Excel 2007.i have little bit know it is available only OLE DB source and OLE DB destination

    but how it is connect

    Thanks

    murali

  • November 20, 2008 at 12:57 pm

    #901252

    You might find this useful

    Look for > Connecting to a Workbook in Excel 2007 Format

    http://msdn.microsoft.com/en-us/library/cc280527.aspx

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

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