I am using an Active X Script task to instantiate an Excel object using
createobject function and it works fine if i run the package manually from
my machine as excel is installed on my machine and DTS runs from my machine
and not from the server but when i try to run the DTS from the SQL Server
machine by logging into the server, it fails because office applications are
not installed on a dedicated SQL Server BOX..I tried using the
CREATEOBJECT's 2nd parameter to instantiate excel from a box where excel is
installed and still it doesnt work..Is that a possibility ? Do i need to run
any DCOMCNFG utility on the machine from where i am trying to instantiate to
add the SQL Server services account..Please let me know..

Thanks,

AFAIK Excel would have to be installed local to the client.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"kneel" <kvatsan (AT) comcast (DOT) net> wrote

Alan,
Thanks for your reply..I am not understanding what you are trying to say..

Thanks,
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

So, there is no way you can instantiate excel object from a different
machine..
Thanks,
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

I am sying that if you want to use Excel programmatically then it must be
local to the PC doing the package execution.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"kneel" <kvatsan (AT) comcast (DOT) net> wrote

Not that I know of. Maybe someone else has done this but I personally have
not and never would.

MS do not support Office automation in a Server Side unattended environment
either.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"kneel" <kvatsan (AT) comcast (DOT) net> wrote

Thanks Alan..I thought the same..But i just wanted to confirm...But also i
thought it doesnt make any sense to have office applications installed on a
dedicated SQL Server box to instantiate any object...
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Yep which is why I keep away from it where possible

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"kneel" <kvatsan (AT) comcast (DOT) net> wrote