<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Dale Parsons
»
Working with DTS in SQL Server 2008
13 posts, Page 1 of 2
1
2
»»
Working with DTS in SQL Server 2008
Rate Topic
Display Mode
Topic Options
Author
Message
krakatoa66
krakatoa66
Posted Sunday, February 14, 2010 10:22 AM
Grasshopper
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
pippo999
pippo999
Posted Monday, February 15, 2010 2:55 AM
Forum 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
krakatoa66
krakatoa66
Posted Monday, February 15, 2010 3:33 AM
Grasshopper
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
Sean Elliott (UK)
Sean Elliott (UK)
Posted Monday, February 15, 2010 4:36 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, April 05, 2013 9:32 AM
Points: 42,
Visits: 170
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
pippo999
pippo999
Posted Monday, February 15, 2010 5:05 AM
Forum 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
srinath Pedi
srinath Pedi
Posted Monday, February 15, 2010 6:52 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, June 02, 2010 12:55 PM
Points: 5,
Visits: 8
Darren Green has created a wonderful tool which is free to use, it is called
DTSBackup
. 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
webtomte
webtomte
Posted Monday, February 15, 2010 8:53 AM
SSC Rookie
Group: General Forum Members
Last Login: Monday, May 13, 2013 4:33 AM
Points: 48,
Visits: 159
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
jasonwhowell
jasonwhowell
Posted Monday, February 15, 2010 11:07 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, February 15, 2013 2:29 PM
Points: 5,
Visits: 48
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
SQLRNNR
SQLRNNR
Posted Monday, February 15, 2010 12:42 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754,
Visits: 12,337
Interesting Article. Thanks
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #865678
jose-276033
jose-276033
Posted Monday, February 15, 2010 1:00 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, August 14, 2012 1:18 AM
Points: 5,
Visits: 36
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 »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
