Create reports with SQL Express

Is it possible to create reports with Sql Express edition i.e. like you can with SQL full edition? If not are there any other add on free tools that allow you to do this?

Thanks

See this link here for the SQL Server toolkit:

http://msdn2.microsoft.com/en-us/library/ms365166.aspx

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Create Package in SQL Server Management Studio Express?

Our server currently has the following components installed for SQL Server 2005: 1. SQL Server Management Studio Express and 2. Configuration Tools (SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server Service Area Configuration).

Is there a way to setup a package using the software currently installed (if not, what needs to be installed in order to setup a package)?

I'm looking to schedule running an executible, it was fairly easy with SQL Server 2000 (using DTS), but I'm unsure how to set this up using the software we currently have installed.

It looks like you are using SQL Sever 2005 express?

Sorry but SSIS doesn't come with express, you'll need Standard edition or better:

see the section, "Integration and Interoperability":

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||P.S. Installing standard edition tools seems to do the trick (be sure to install Integration Services).

Create Mapping Schema file

What are the tools which are avilable to create the
mapping schema file to load data from XML file to SQL
Server?
Thanks
Kokoy
"Mkokoy" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5a701c44e57$872114f0$a501280a@.phx.gbl...
> What are the tools which are avilable to create the
> mapping schema file to load data from XML file to SQL
> Server?
There aren't a lot of them. I think xmlspy has one http://www.xmlspy.com
Bryant