dbTalk Databases Forums  

DTSRun: Cannot Create COM server to load and execute DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTSRun: Cannot Create COM server to load and execute DTS package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Niki AU
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.