Hi -- My company is in the process of upgrading their SQL Server 2000 data warehouse to SQL Server 2008. Note that my company currently uses the BI toolset from SQL Server 2005. However, my company has no plans to upgrade the 2005 BI services
that we currently use. Will this configuration work?
Back-end Database Engine: SQL Server 2008, SP-2
Back-end BI Services: SQL Server 2005, SP-3 (SSAS, SSIS, SSRS - each on their own server)
Front-end Client Tools: SQL Server 2008, SP-2 (SSMS, BIDS)
My concern is that I would, for example, develop an SSIS package on my laptop with the 2008 client toolset and it would work just fine. But when the package is run in production on the SSIS box (that contains only the 2005 SSIS service), it might
complain because it doesn't understand the 2008 package structure. Or is the SSIS service smart enough to detect the version of the package and work as if nothing was wrong?
Thanks in advance for your help.
View Complete Post