Sunday, February 19, 2012

DTS in SP Error

I have a DTS package already created on the server. I want to call it
in a sp using the xp_cmdshell 'dtsrun ...'
I'm getting "xpsql.cpp: Error 87 from GetProxyAccount on line 604"
Any ideas how to fix this?
Thanks
MikeI found the fix for this error but I have a new problem
This DTS package is supposed to drop the table if it exists then create
a new one and load data from an excel file. This works fine if I run it
manually from enterprise manager.
If I try to run it from query analyzer i get an error stating that the
directory is not a valid path. And it doesn't drop the table first.
Any ideas?|||I suppose that when you run that package from QA you are using a different
user than EM or something like that. And that user doesn't have permissions
over that folder.
--
Current location: Alicante (ES)
"Mike" wrote:

> I found the fix for this error but I have a new problem
> This DTS package is supposed to drop the table if it exists then create
> a new one and load data from an excel file. This works fine if I run it
> manually from enterprise manager.
> If I try to run it from query analyzer i get an error stating that the
> directory is not a valid path. And it doesn't drop the table first.
> Any ideas?
>

No comments:

Post a Comment