DTS sql 7 ERROR -exporting query into excel 2000
am 29.11.2004 20:48:35 von jason
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
am 29.11.2004 23:32:21 von jason
Identified problem....my web host will not allow me to save dts packages on
their server...needs to be done locally....!
wrote in message
news:%23fQalxk1EHA.3324@tk2msftngp13.phx.gbl...
> 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
>
>