InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 12:30:34 GMT20http://www.sqlservercentral.com/Forums/Topic769892-630-1.aspxThanks for the article-- this was a lifesaver for me. Same scenario as you, I believe: SQL2008 database but SQL 2005 SSIS packages that needed to be run. It's absurd that you had to create all those aliases; didn't Microsoft have any backward compatibility in mind on this subject?Wed, 17 Feb 2010 17:17:38 GMTlarryqhttp://www.sqlservercentral.com/Forums/Topic769892-630-1.aspxGood info. Still reeling under 2005 and only got couple of Dev servers in 2008. But it's good to know info before in time.Thu, 13 Aug 2009 11:38:00 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic769892-630-1.aspxI had to add the following stored procedure to be able to save in SSIS packageCREATE PROCEDURE [dbo].[sp_dts_getfolder] @name sysname, @parentfolderid uniqueidentifierAS SELECT folder.folderid, folder.foldername, folder.parentfolderid, parent.foldername FROM sysssispackagefolders folder LEFT OUTER JOIN sysssispackagefolders parent ON folder.parentfolderid = parent.folderid WHERE folder.foldername = @name AND (folder.parentfolderid = @parentfolderid OR (@parentfolderid IS NULL AND folder.parentfolderid IS NULL))Thu, 13 Aug 2009 07:56:10 GMTkevin gouxhttp://www.sqlservercentral.com/Forums/Topic769892-630-1.aspxInstead of creating new SPs (with old names) calling the existing ones (with new names), it would be better to create synonyms...Thu, 13 Aug 2009 06:53:00 GMTCédric Dolainhttp://www.sqlservercentral.com/Forums/Topic769892-630-1.aspxSeems like a lot of trouble to go through. A better option would be to stand up a new 2008 test/upgrade environment on another server to allow developers to continue to support 2005 with their existing development environment. Alternatively if this is not possible, promote 2005 development to 2008 and leave the QA environment on 2005 to match production. The new 2008 replaces existing development upon production upgrade. QA is then upgraded shortly after production.Thu, 13 Aug 2009 06:00:12 GMTcmille19http://www.sqlservercentral.com/Forums/Topic769892-630-1.aspxThank you for the great article. I am sure that many will find it helpful. Recently I had some problems with my BI studio myself: I had created a SSRS report in 2005, and under no condition would that report run under 2008. A very sad story. I ended up re-creating the same report in 2008 just so I can release it...Thu, 13 Aug 2009 01:21:31 GMTsibir1ushttp://www.sqlservercentral.com/Forums/Topic769892-630-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Integration+Services+(SSIS)/67201/">How to Resolve a BIDS 2005 and SQL Server 2008 Compatibility Issue</A>[/B]Thu, 13 Aug 2009 00:18:21 GMTMohan Kumar