DTS for SQL Server 2005 Express Edition

views:

741

answers:

DTS for SQL Server 2005 Express Edition

What did Microsoft rename DTS to for SQL Server 2005 Express Edition?

Where is the download link to the SQL Server 2005 Express Edition DTS utility?

i've been searching for half an hour, and i can't find a definitive answer.

i need to import data from a data source into an SQL Server 2005 Express Edition database.

+1 A:

DTS is renamed SSIS and SSIS is not part of Express editions.

Remus Rusanu 2009-07-24 05:46:01

So, to confirm, you cannot import data into SQL Server 2005 Express Edition?

Ian Boyd 2009-07-24 05:48:34

With SQL Express you don't have the SSIS runtime and editors. But you can develop SSIS packages on a payed edition and have them import/export data from/to an Express edition though.

Remus Rusanu 2009-07-24 05:56:12

'Import' is a pretty broad term. In addition to SSIS, there's also BULK INSERT if you're familiar with that.

DaveE 2009-07-24 06:03:43

@Remus: Is SSIS really DTS renamed? I have always understood SSIS to be a completely new SQL Server Technology, rather than say an upgrade to an existing one (DTS)?

John Sansom 2009-07-24 08:06:45

I mean 'rename' as in the 'the feature formerly known as DTS is now known as SSIS'. It is a complete rewrite indeed, since the technology had to change from native and COM to managed and CLR. In that sense is not an 'upgrade'. But as scope, usage scenarios and functionality it clearly extends on the DTS concepts.

Remus Rusanu 2009-07-24 08:30:08

DTS is not longer available in it's pure form in SQL Server 2005 and above.

A new technology platform called SQL Server Integration Services (SSIS) was developed and has replaced the functionality previously on offer via Data Transformation Services (DTS).

For instructions on how to "migrate" DTS packages to SSIS refer to the following Microsoft Books Online Reference: Migrating Data Transformation Services Packages

John Sansom 2009-07-24 08:33:54

ansaurus

tags:

views:

answers:

DTS for SQL Server 2005 Express Edition

related questions