[dba-SQLServer] DTS

Jim Lawrence accessd at shaw.ca
Thu Feb 16 23:13:13 CST 2006


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



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list