Thanks, Dugi.

The Access database is not password protected. The linked server works sometimes (once a day), but it fails often.

Thanks for your advice, Dan.

Thank you all for your responses.

Greg, can you point me to reference material for exposing Reporting Services to WSS?

Thanks.

Most of our users are still on Excel 2000. I noticed in the Data menu of Excel 2000 that there are 'Get External Data' and 'Pivot Table and Pivot...

Thanks, Gila.

Thanks, Jack.

Thanks, Luke. Is there a work-around or an alternative to using sp_send_dbmail to send email?

What I've just discovered is that when I close Excel after the export fails, and then export again to Excel (a second export), it works.

Thanks d_sysuk.

There is a significant amount of code that is executed to determine the value of the variable @EST_COST. That's why I'm using a cursor.

Are temp tables updatable in...

It looks like the server name parameter (-S) must be in uppercase.

This worker:

C:\>sqlcmd -S lebhq-actsql\itdev

1> select @@servername

2> go

---------------------------------

---------------------------------

LEBHQ-ACTSQL\ITDEV

(1 rows affected)

Thanks Todd,

sqlcmd is using the default instance and not the named instance I specify (lebhq-actsql\itdev).

Any suggestions?

C:\>sqlcmd -s lebhq-actsql\itdev

1> select @@servername

2> go

--------------------------------------------------------------------------------

------------------------------------------------

LEBHQ-ACTSQL

(1 rows affected)

1> select name from sys.databases

2> go

name

--------------------------------------------------------------------------------

------------------------------------------------

master

tempdb

model

msdb

ReportServer

ReportServerTempDB

(6 rows affected)

1>...

I don't believe there is any such thing as user-level security in SSRS.

However, if you want to make report data sensitive to a user, then look into using the UserID...

Try this.

1. Open the SQL Server Configuration Manager.

2. For the SQL Server Agent process,...

Thanks, Antonio. That was it! I ended up using this syntax:

Insert Into dbo.PLExchRate

Select CCNVFC

From OpenQuery(DRAS400,'Select CCNVFC From BPCSFFG.GCC

Where CCFRCR = ''USD''

And CCTOCR = ''PLN''

And CCRTYP...

Thanks, Michael.