No Import/Export Option in Mgmt Studio Express

Hi,

I just installed SQL Server 2005 Express. I would like to import tables from

another DB, and I read in the help files that I just need to (1) right-click on

a non-system database in Management Studio Express, and (2) select Import/Export

under the Tasks menu.

I tried this, but my Tasks menu only contains these options: Detach, Shrink,

Backup, Restore, Generate Scripts.

I googled for \"sql server 2005 "no import" tasks\", and it appears that a

couple of people have had this problem -- the only solution I read was to

install the "Workstation Components," but I already have, and still no luck.

Any idea what I need to do? Thanks!

Did you try right clicking on the database in the object explorer window. Try that, and then the All Tasks, Generate SQL Scripts option.|||Okay, I right-clicked on my database in the object explorer, then went to Tasks->Generate Scripts. This database is empty, though (I want to import a SQL Server 7 DB into it), so I end up getting a message that says "There are no objects in database of the types scriptable by this wizard."

Ultimately, I just need to import a SQL Server 7 database into SQL Server 2005 Express, but I can't find an "import" option in 2005. Is there some component I need to install?|||Ah, I think I need SQL Server Integration Services (SSIS), and that is apparently not included in SQL Server 2005 Express Edition (see "Unsupported Features" in http://msdn2.microsoft.com/en-us/library/ms365166.aspx). Mystery solved.

No Error but Export to Excel does not finish

No Error but Export to Excel does not finish

When the report has 2 pages with total 500 rows exporting to Excel is not a problem.

If it has 100 pages 5000 rows exporting to excel does not end and it does not return any error but the process does not end either. What might the problem be?

How you are exporting?

Are you using SSIS or DTS package?

I don't see any relation between reporting services & export to excel or are you trying to save as EXCEL spreadsheet.

|||

In there report manager, I run the report and then choose excel and export.

|||

Try increasing the value of MemoryLimit in the RSReportServer.config file available under Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer folder. The default value is 60, try increasing to a higher value but keep it under 120.

Shyam

sql