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 12»»

Working with DTS in SQL Server 2008 Expand / Collapse
Author
Message
Posted Sunday, February 14, 2010 10:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 11, 2011 10:31 AM
Points: 12, Visits: 158
Comments posted to this topic are about the item Working with DTS in SQL Server 2008
Post #865292
Posted Monday, February 15, 2010 2:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 16, 2010 1:16 AM
Points: 2, Visits: 6
Hello

thanks for the interesting article.
I started the procedure to install and activate DTS support on 2008 server, but even if I have
- Integration Services.
- Client Tools Backward Compatibility.
installed on my SQL2008, when I launch SQLServer2005_BC for my system I get the error
"Installation of Microsoft SQL Server 2005 Backward compatibility
failed
because a higher version already exists on the machine. To proceed,
uninstall the higher version and then run Microsoft SQL Server 2005
Backward compatibility setup again."

How can I solve it?

Thanks

Paolo



Post #865428
Posted Monday, February 15, 2010 3:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 11, 2011 10:31 AM
Points: 12, Visits: 158
Hi Paolo,

Did you look for SQL Server 2005 Backward Compatibility in Add/Remove Programs? If its there try unistalling it and then try your install again.

Dale
Post #865435
Posted Monday, February 15, 2010 4:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 8:59 AM
Points: 42, Visits: 178
There is also an extra permissioning step required in order to be able to execute DTS packages in SQL 2008. All SQL Server logins which need to run a package need to be users in the msdb database with membership of one of the SSIS roles. We use db_ssisoperator.
Post #865459
Posted Monday, February 15, 2010 5:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 16, 2010 1:16 AM
Points: 2, Visits: 6
krakatoa66 (2/15/2010)
Hi Paolo,

Did you look for SQL Server 2005 Backward Compatibility in Add/Remove Programs? If its there try unistalling it and then try your install again.

Dale


Yes checked before posting. No prev installation. I googled about this issue but found no definitive post or article about it.

Thanks



Post #865468
Posted Monday, February 15, 2010 6:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 2, 2010 12:55 PM
Points: 5, Visits: 8
Darren Green has created a wonderful tool which is free to use, it is calledDTSBackup . We have been using this tool for more than six years, for moving DTS packages from one system to another. This tool also enables to move the packages across different versions of SQL Server. We have used it on SQL Server 2000; SQL Server 2008 and between them.

The tool is very simple to use and it moves packages under few minutes. In our environment when we moved about 100 packages; about 20 them were large; it was completed under 5 minutes.

Enjoy
Post #865510
Posted Monday, February 15, 2010 8:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 12:35 AM
Points: 80, Visits: 215
There is an excellent software that can convert DTS packages to SSIS packages from a company called pragmatic works. I have done this recently and it works. I had to do some code adjustments (cast and stuff) on one column only. Otherwise it worked superbly.

So now I do not have to worry about DTS packages anymore as they are depreceated by Microsoft.
Post #865569
Posted Monday, February 15, 2010 11:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 13, 2013 10:26 PM
Points: 5, Visits: 49
The newer runtime dtexec.exe doesn't run DTS 2000 packages natively. It runs SSIS 2005/2008 packages with the [Execute DTS 2000 Package Task] embedded as a task in the control flow.

The easier runtime to run DTS 2000 packages is DTSRun.exe.
Which can be installed via the Backward Compatibility SQLServer2005_BC*.msi or from the latest feature pack download for SQL 2008.
http://msdn.microsoft.com/en-us/library/ms143755.aspx

You should also mention that DTS 2000 is deprecated, and might not be supported in future releases of SQL Server. http://msdn.microsoft.com/en-us/library/ms403408.aspx

Most of these topics are covered in MSDN
http://msdn.microsoft.com/en-us/library/bb500440.aspx
Post #865637
Posted Monday, February 15, 2010 12:42 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:05 PM
Points: 17,814, Visits: 15,741
Interesting Article. Thanks



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #865678
Posted Monday, February 15, 2010 1:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 11:41 PM
Points: 5, Visits: 40
Hi,
we had the same situation and we did the same. Some of them where using activex so it was abit of a challenge to makes them work again

Thanks for sharing

Jose
Post #865686
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse