DTSRun: Cannot Create COM server to load and execute DTS package -
08-06-2009
, 09:29 AM
Hi All,
i have a tedious problem:
I need to execute a remote DTS from a client machine(the application
server), with DTSRun tool. The problem is that on the client machine i
cannot install sql server, so after reading http://www.sqldts.com/225.aspx
(Redistributing DTS with your program), i placed all the DLL specified in
the previous link and registered them. Now if i execute DTSRun with an
administrative account it work fine, otherwise if i use a non-administrative
account it doesn't work(the only message is the one specified in the
object). It's obvious my application cannot be executed with administrative
privileges.
My client application run on a SQLServer 2003 machine with SP1 installed.
Any Ideas?
Thank you |