Post reply

importing data from 2008 named instance to 2005

  • May 29, 2013 at 9:42 pm

    #293934

    Hi All,

    I am planning to copy a data from SQL server 2008 Enterprise Edition to SQL server 2005 Enterprise edition and data needs to be refreshed everyday ones.

    What are the best possible options available to do this.

    While connecting through SSIS using Microsoft OLEDB provider FOR SQL server i am getting below error :

    Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    Please help with any useful links or suggest

    Thanks,

    Gangadhara MS

  • May 30, 2013 at 12:33 am

    #1619561

    You could use the import/export wizard and save the generated SSIS package upon completion. This gives you an initial test and if it works, you can call the generated SSIS package form a daily SQL Agent job.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • May 30, 2013 at 3:37 am

    #1619603

    OK thank you But i am looking at incremental data refresh,, I mean i have a column date_modified based on that column i need to refresh the data dialy ones.

    Thanks,

    gAnGa

  • May 30, 2013 at 4:28 am

    #1619607

    Once you have created a SSIS package from the import/export wizard, you know the connection managers are correct. You can load the generated SSIS package in BIDS and adjust it to your needs.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

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

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