MartyConnelly
martyconnelly at shaw.ca
Thu Feb 16 23:22:41 CST 2006
If you are having trouble removing bits and pieces of an install made via the windows installer, Locate and run the MS Windows Installer CleanUp Utility msicuu2.exe. Some users have said they removed Symantec after faulty install and Visio without a necessary CD. Here is a brief article on it and download URL http://techrepublic.com.com/5100-10877_11-6030075.html?tag=nl.e064 or have a look through MSDN SQL Express Blog http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172956.aspx Jim Lawrence wrote: >Hi Marty: > >Thanks for the heads up on that. I had found the new SSIS Integration >Services but had not yet discovered the section legacy folder. (In my >opinion MS SQL has gone a little over the top with features and >functionality... it is starting to look like Enterprise Oracle and not the >type little powerful SQL 2000.) > >Jim > >Now I have a heck of a problem removing some old versions of SQL Express >from a client's server. (Wished the beta stuff had been installed in a >Virtual PC.) I have just re-run VS-uninstall-betas after everything was >carefully removed through the Control Panel. (twice??) > >-----Original Message----- >From: dba-sqlserver-bounces at databaseadvisors.com >[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of >MartyConnelly >Sent: February 16, 2006 8:15 PM >To: dba-sqlserver at databaseadvisors.com >Subject: Re: [dba-SQLServer] DTS > > You can run DTS (SS2000) from SS2005. >Under 2005 Mgt Studio is a folder called Legacy under Management folder. > SSIS Integration Services is the new name for the DTS > >Jim Lawrence wrote: > > > >>Hi All: >> >>I have just upgraded a client's SQL 2000 DB to SQL 2005 and a number of >>objects have been changed, modified or 'wandered'. One issue that is a >> >> >major > > >>problem is the original (2000) had a number of DTS executable files that >>were used to import some raw data through various function and SP calls. >> >>The DTS files have disappeared or when it is manually attempted to >> >> >re-create > > >>the process again the results seem to disappear(?) >> >>There must be so obvious reason for this but at this late hour it is not >>obvious. >> >>Any help or comments would be greatly appreciated... (I am going for a >>coffee.) >> >>Jim >> >>_______________________________________________ >>dba-SQLServer mailing list >>dba-SQLServer at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >>http://www.databaseadvisors.com >> >> >> >> >> >> >> > > > -- Marty Connelly Victoria, B.C. Canada