linking lotus notes with sql server 2005 express

  • iam using sql server 2005 express. we have two branches for our company.we have lotus notes is the only connectivity...i also have sql server in other branch...

    can i get the sql data from other branch to my server when they saving...???

    if so pls explain me in detail...

  • Didnt know that you have Integration Services with SQL Server Express

  • i dont know it...

  • seenu_61281 (6/20/2008)


    iam using sql server 2005 express. we have two branches for our company.we have lotus notes is the only connectivity...i also have sql server in other branch...

    can i get the sql data from other branch to my server when they saving...???

    if so pls explain me in detail...

    Hey, This is very simple. You can do it with SSIS packages. Even I am transfering the data from lotus notes db to SQL Server db. If you need any thing I can help you.

    Thank You

  • i tried for ssis....i dont know what it is??? from where i can download the setup ?

    is it compatible with sql 2005 express? if so pls help me step by step

  • Hey,

    SSIS does not come with your particular version of SQL (Express)

  • can i download the setup ?

    is it compatible with sql 2005 express?

  • No you cant.

    SSIS only ships with Standard and Enterprise Editions

    http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

    Upgrade...

    ~PD

  • ok..thank u...

  • Hi Venki,

    If you could explain me how you extract data from Lotus Notes with an SSIS package that would be great.

    Thanks,

    Ansj

Viewing 10 posts - 1 through 9 (of 9 total)

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