While installing the trial of SQL Server 2008 will get you the full Management Studio and Business Development Studio (or whatever it is called in 2008, and is required for developing SSIS solutions), SQL Server Express does not have the SSIS service. You have to have at least one full SQL Server 2008 server somewhere to have an SSIS service. You might consider purchasing SQL Server 2008 Developer Edition (which should be about $50) which is essentially a fully functioning version of SQL Server 2008 Enterprise with the licensing restriction that it only be used for development and not production.
Link to Developer Edition on MicrosoftStore.com: http://www.microsoftstore.com/store/msstore/en_US/pd/productID.221634300/search.true HTH, Carl On 5/11/2011 8:08 AM, Russ Michaels wrote: > I'm sure I used SSIS with 2005 Express, so I would expect it is with 2008. > You certainly have import/export services anyway. > Just make sure you get SQL Server Express with Tools. > If you find features missing from the Management Studio express, there is a > little cheat, you can download the FULL EDITION trial of SQL Server 2008 > with tools, and get the full edition of Management Studio, which i'm pretty > sure never expires, at least it didn't with 2005. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm