How to direct a data source view to another data source

• Sid Childers

  Ten Centuries

  Points: 1079

  More actions

  September 12, 2013 at 10:02 am

  #144640

  Hi,

  We are doing a parallel migration from SQL Server 2005 to 2008 R2. We've moved the database, Integration Services and Analysis Services over to the 2008 R2 server. In BIDS, I've migrated the solution successfully into BIDS 2008 and created a new data source for the 2008 R2 server.

  Is it possible to piont the Data Source View to the new server? Or, do I need to create a new Data Source View that is based on the new server?

  Thanks for your help and guidance.