inetserver asp db: DTS sql 7 ERROR -exporting query into excel 2000 -- inetserver asp db

DTS sql 7 ERROR -exporting query into excel 2000

jason NO[at]SPAM catamaranco.com
11/29/2004 2:48:35 PM

inetserver asp db:

With the help of Gary Jones I constructed a query and attmepted to use the
DTS export facility to save and export the query into excel.

However, on upon completing the final step in the process I am presented
with a security error....Google has not helped...can anyone tell me why this
simple process should be interrupted. Here is the error:

MICROSOFT OLE DB PROVIDER FOR SQL SERVER ERROR
------------------------------------------------------------------------
Execute permission denied on object 'sp_add_dtspackage', 'database', 'msdb',
owner, 'dbo'.

The query itslf is pretty straightforward and parses correctly:

SELECT URLCurrent AS Page, COUNT(*) AS Hits
FROM UserInquiry
WHERE (CHARINDEX('@catamarans.com', u_name) = 0)
GROUP BY URLCurrent

Appreciate any help you can give me.

Best Regards
Jason

Re: DTS sql 7 ERROR -exporting query into excel 2000

jason NO[at]SPAM catamaranco.com
11/29/2004 5:32:21 PM

Identified problem....my web host will not allow me to save dts packages on
their server...needs to be done locally....!
[quoted text, click to view]