beginner question

#1

can not see how to create a DTS package, using SQL Measurement studio,
thanks. I have created many using Enterprise manager with sql2000.
--
Paul G
Software engineer.

#2

You cannot create new ones as DTS is a legacy component, but you can import
and edit existing ones. To do the latter, you need to download the Microsoft
SQL Server 2000 DTS Designer Components from this page to use with your SQL
Server Management Studio for 2005:

http://www.microsoft.com/downloads/d...displaylang=en

--
AndyP,
Sr. Database Administrator,
MCDBA 2003

"Paul" wrote:

Quote:

can not see how to create a DTS package, using SQL Measurement studio,
thanks. I have created many using Enterprise manager with sql2000.
--
Paul G
Software engineer.

#3

Hi thanks for the information. Is there an equivalent to the dts package in
mssql 2005 so you can create and schedule data moves between databases and so
on ?
--
Paul G
Software engineer.

"AndyP" wrote:

Quote:

You cannot create new ones as DTS is a legacy component, but you can import
and edit existing ones. To do the latter, you need to download the Microsoft
SQL Server 2000 DTS Designer Components from this page to use with your SQL
Server Management Studio for 2005:

http://www.microsoft.com/downloads/d...displaylang=en

--
AndyP,
Sr. Database Administrator,
MCDBA 2003

"Paul" wrote:

can not see how to create a DTS package, using SQL Measurement studio,
thanks. I have created many using Enterprise manager with sql2000.
--
Paul G
Software engineer.

#4

Hello Paul,

The ETL offering from MS is now called SQL Server Integration Services.
You can find it in the Business Intelligence Development Studio.

have a look here for some of the things you can do in SSIS

www.SQLIS.com

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Hi thanks for the information. Is there an equivalent to the dts
package in mssql 2005 so you can create and schedule data moves
between databases and so on ?

"AndyP" wrote:

You cannot create new ones as DTS is a legacy component, but you can
import and edit existing ones. To do the latter, you need to download
the Microsoft SQL Server 2000 DTS Designer Components from this page
to use with your SQL Server Management Studio for 2005:

http://www.microsoft.com/downloads/d...d=d09c1d60-a13
c-4479-9b91-9e8b9d835cdc&displaylang=en

--
AndyP,
Sr. Database Administrator,
MCDBA 2003
"Paul" wrote:

can not see how to create a DTS package, using SQL Measurement
studio,
thanks. I have created many using Enterprise manager with sql2000.
--
Paul G
Software engineer.

#5

Hi I installed the dts download and opened a mssql2000 database but still the
dts packages are not visible. I do have the trial version of mssql2005 so
perhaps this is why.
--
Paul G
Software engineer.

"AndyP" wrote:

Quote:

You cannot create new ones as DTS is a legacy component, but you can import
and edit existing ones. To do the latter, you need to download the Microsoft
SQL Server 2000 DTS Designer Components from this page to use with your SQL
Server Management Studio for 2005:

http://www.microsoft.com/downloads/d...displaylang=en

--
AndyP,
Sr. Database Administrator,
MCDBA 2003

"Paul" wrote:

can not see how to create a DTS package, using SQL Measurement studio,
thanks. I have created many using Enterprise manager with sql2000.
--
Paul G
Software engineer.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

beginner question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

beginner question - 03-17-2006 , 02:47 PM

RE: beginner question - 03-20-2006 , 01:48 PM

RE: beginner question - 03-20-2006 , 02:35 PM

RE: beginner question - 03-20-2006 , 03:12 PM

RE: beginner question - 03-20-2006 , 06:09 PM