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.