Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Resolve a BIDS 2005 and SQL Server 2008 Compatibility Issue Expand / Collapse
Author
Message
Posted Thursday, August 13, 2009 12:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 3, 2013 4:44 PM
Points: 1,336, Visits: 595
Comments posted to this topic are about the item How to Resolve a BIDS 2005 and SQL Server 2008 Compatibility Issue

--www.sqlvillage.com
Post #769892
Posted Thursday, August 13, 2009 1:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 2:22 AM
Points: 22, Visits: 292
Thank 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...

Make everything as simple as possible, but not simpler.
Albert Einstein
Post #769927
Posted Thursday, August 13, 2009 6:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:01 AM
Points: 258, Visits: 701
Seems 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.


Post #770067
Posted Thursday, August 13, 2009 6:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:36 AM
Points: 1,406, Visits: 68
Instead of creating new SPs (with old names) calling the existing ones (with new names), it would be better to create synonyms...
Post #770106
Posted Thursday, August 13, 2009 7:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 25, 2013 5:38 AM
Points: 30, Visits: 167
I had to add the following stored procedure to be able to save in SSIS package

CREATE PROCEDURE [dbo].[sp_dts_getfolder]
@name sysname,
@parentfolderid uniqueidentifier
AS
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))
Post #770170
Posted Thursday, August 13, 2009 11:38 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Good info. Still reeling under 2005 and only got couple of Dev servers in 2008. But it's good to know info before in time.

SQL DBA.
Post #770367
Posted Wednesday, February 17, 2010 5:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 19, 2010 2:42 PM
Points: 3, Visits: 7
Thanks 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?
Post #867635
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse