Re: Sql 2005 express edition information

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 11/09/05

  • Next message: Sophie Guo [MSFT]: "Re: Linked Servers" 
    Date: Wed, 9 Nov 2005 08:46:27 +0100

    > Dunno what SSIS is yet... but it says here explicitly:

    SSIS (SQL Server Integration Services) is the successor of DTS. 

    -- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ross Presser" <rpresser@NOSPAMgmail.com.invalid> wrote in message 
news:obcn310yndyr$.dlg@rosspresser.dyndns.org...
> On Tue, 8 Nov 2005 20:46:57 +0100, Tibor Karaszi wrote:
>
>> Sorry, I forgot to post the URL:
>> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>>
>>> Of course, nothing says you can't roll-your-own replication-like facility
>>> using DTS packages, right?
>>
>> Hmm, I'm no DTS (SSIS) expert, but according to the URL above, Express doesn't include Agent, nor
>> SSIS (I might be misinterpreting the SSIS part, though).
>
> The Agent is convenient, but any user-written program could substitute for
> it.
>
> Dunno what SSIS is yet... but it says here explicitly:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
> ...
> Comparison with MSDE
> ...
> However, some features are removed from SQL Server Express compared to
> MSDE. These features include DTS, replication publishing, and SQL Agent.
>
> On the other hand, lower down it says that "DTS [is available] in separate
> download".  So, I'm confused.
>
> Well, even DTS isn't strictly necessary for rolling your own; a determined
> hacker could develop a substitute that did it all with regular SQL access
> methods. Would probably spend more time doing it than it's worth, though --
> just go buy a different edition.
  • Next message: Sophie Guo [MSFT]: "Re: Linked Servers"

    Relevant Pages

    • Re: Downgrade to 32bit version of SQL2005?
      ... if you choose to _migrate_ your DTS package into SSIS then: ... ""Data Driven Query" tasks in SQL Server 2000 DTS package will not be ...
      (microsoft.public.sqlserver.setup)
    • Re: Copying truncates strings of spaces?
      ... I'd just reccomend buying a developers edition of SQL Server; ... building an SSIS package and then running it via the command line. ... do know that MSDE 2.0 would allow this; it included the Dts ... Whenever I 'select all records' and copy the data into Excel, ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Upgrading DTS to SSIS
      ... You cannot run packages outside of BI Development Studio on a client computer that does not have Integration Services installed, and the terms of your SQL Server 2005 licensing may not permit you to install Integration Services on additional computers. ... SQL Server 2005 Integration Services (SSIS) is now a server component and is not redistributable to client computers in the same manner that the components required for SQL Server 2000 Data Transformation Services (DTS) were redistributable. ...
      (microsoft.public.sqlserver.dts)
    • Re: SSIS and DTS
      ... DTS package composition info is not stored inside of any SQL Server tables. ... You can access both pieces of info using the respective objent models or in SSIS you could use XQuery to read the XML ...
      (microsoft.public.sqlserver.dts)
    • Re: SQL 2000 - Connection Error with DTS Packages
      ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
      (microsoft.public.sqlserver.dts)