first_page

Less is more with SQL Server Express?

MSDE was almost completely ignored by me as my work has been dominated by Web applications that had easy access to full-blown SQL Server 2000. With SQL Server 2005 on the scene, Microsoft has me kicking it like Tiny Elvis—that sucker’s huge!

The only need I see for SQL Server 2005 over SQL Express 2005 is the possibility that my legacy DTS packages need to migrate to SQL Server Integration Services. However, I may see later that the presence of the CLR in SQL Express may eliminate the need for many or all of my old DTS packages.## Resources

[Data Transformation Services for SQL Server 2005-Frequently Asked Design Questions](http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/dtsfss05df.asp) A somewhat historical article not using the SSIS acronym that could disappear from MSDN at any moment.
[sqlis.com](http://www.sqlis.com/) Clearly by the same guys that put together SQLDTS.com.

rasx()