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 Monday, February 15, 2010 1:40 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 11, 2011 10:31 AM
Points: 12, Visits: 158
Yes checked before posting. No prev installation. I googled about this issue but found no definitive post or article about it.

Thanks


I have read online that it may not always appear in Add\Remove programs but to be completely sure that there is no registry entry you can download and install Windows
Installer Cleanup Wizard. There's a good chance this will pick it up.
Post #865699
Posted Thursday, May 13, 2010 5:48 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, September 15, 2014 6:42 AM
Points: 365, Visits: 940
Srinath what a great call you gave about "DTS Backup 2000"!!!

First off I couldn't get the DTS package stuff working on one of the machines. Just wouldn't work. Then found out you need the enviromental variables (path variable to be exact) in the correct order - this may negate having to copy files between the directories as proposed by krakatoa66 in the article.

i.e references to the sql 2000 (80) should appear before sql 2005/2008 (90/100).

Now I'd tried every trick in the book to open DTS packages on 2008, couldn't find a thing to work for certain packages.

I'd reinstalled the DTS components, repaired them, and all sorted. I tried following this blog as well:

http://blogs.msdn.com/sqlserverfaq/archive/2009/07/09/error-sql-server-2000-dts-designer-components-are-required-to-edit-dts-packages-install-the-special-web-download-sql-server-2000-dts-designer-components-to-use-this-feature-microsoft-sqlserver-dtsobjectexplorerui-ssms.aspx

Got nowhere. Was going to ask for the dll file mentioned, but turned out I had it on my machine and that too couldn't open certain packages. I think it may be a case of packages created pre SQL 2000 SP3/4.

Then tried the DTS Backup 2000 program, and hey presto, worked a ruddy charm.

Anyway, Srinath, that tool made all the difference! And obviousily thanks to Daren and Allan at SQLDTS.com!

Kevin

Post #921158
Posted Thursday, May 13, 2010 5:57 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
You are most welcome!!!.

I understand your frustation!!!. Till this day, I couldn't configure this on my PC but my DBA did configure the DTS package stuff on both of our servers....


Fozzie (5/13/2010)
Srinath what a great call you gave about "DTS Backup 2000"!!!

First off I couldn't get the DTS package stuff working on one of the machines. Just wouldn't work. Then found out you need the enviromental variables (path variable to be exact) in the correct order - this may negate having to copy files between the directories as proposed by krakatoa66 in the article.

i.e references to the sql 2000 (80) should appear before sql 2005/2008 (90/100).

Now I'd tried every trick in the book to open DTS packages on 2008, couldn't find a thing to work for certain packages.

I'd reinstalled the DTS components, repaired them, and all sorted. I tried following this blog as well:

http://blogs.msdn.com/sqlserverfaq/archive/2009/07/09/error-sql-server-2000-dts-designer-components-are-required-to-edit-dts-packages-install-the-special-web-download-sql-server-2000-dts-designer-components-to-use-this-feature-microsoft-sqlserver-dtsobjectexplorerui-ssms.aspx

Got nowhere. Was going to ask for the dll file mentioned, but turned out I had it on my machine and that too couldn't open certain packages. I think it may be a case of packages created pre SQL 2000 SP3/4.

Then tried the DTS Backup 2000 program, and hey presto, worked a ruddy charm.

Anyway, Srinath, that tool made all the difference! And obviousily thanks to Daren and Allan at SQLDTS.com!

Kevin

Post #921162
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse