How to open files type SQLSUO & SQLSSMSSLN from sql express 2008 R2

Question

I would like to be able to open solution and project files in SSMS. I would also like to be able to design SSIS packages. Is there any free version of sql 2008 r2 that I can upgrade to or how should I proceed?

Thanks

Answer 1

From

http://technet.microsoft.com/en-us/library/cc645993(SQL.105).aspx#SSIS

Integration Services

Feature	Datacenter	Enterprise	Standard	Web	Workgroup	Express with Advanced Services	Express Tools	Express
SQL Server Import and Export Wizard	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Built-in data source connectors	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Integration Services designer and runtime	Yes	Yes	Yes
Basic tasks and transformations in addition to those used by the Import and Export Wizard	Yes	Yes	Yes
Log providers and logging	Yes	Yes	Yes
Basic data profiling tools	Yes	Yes	Yes
Programmable object model for extensibility	Yes	Yes	Yes

Integration Services - Advanced Adapters

Feature Name	Datacenter	Enterprise	Standard	Web	Workgroup	Express with Advanced Services	Express with Tools	Express
High performance Oracle destination	Yes	Yes
High performance Teradata destination	Yes	Yes
SAP BW source and destination	Yes	Yes
Data mining model training destination adapter	Yes	Yes
Dimension processing destination adapter	Yes	Yes
Partition processing destination adapter	Yes	Yes

Integration Services - Advanced Transforms

Feature Name	Datacenter	Enterprise	Standard	Web	Workgroup	Express with Advanced Services	Express with Tools	Express
Persistence (high performance) lookups	Yes	Yes
Data mining query transformation	Yes	Yes
Fuzzy grouping and lookup transformations	Yes	Yes
Term extractions and lookup transformations	Yes	Yes

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.