Activex DLL Task scheduled problem

#1

Why, when i scheduled a dts package containing an ActiveX Dll Task, the job doesn't enter in the ActiveX?

#2

Only do it when scheduled?
Work manually?

Usually it can be resolved by reading this

http://support.microsoft.com/?kbid=269074

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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

"gorack" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Why, when i scheduled a dts package containing an ActiveX Dll Task, the
job doesn't enter in the ActiveX?

#3

In message <B801F64C-5C0D-4746-B6B8-ABCAC10EAABE (AT) microsoft (DOT) com>, gorack
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Why, when i scheduled a dts package containing an ActiveX Dll Task, the
job doesn't enter in the ActiveX?

As well as reading the KB Allan posted, if the Dll was written in VB,
try setting the ActiveX Script Task to execute on the main package
thread. This is found under the Workflow Properties for the task (step).

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Activex DLL Task scheduled problem

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

Activex DLL Task scheduled problem - 01-30-2004 , 08:41 AM

Re: Activex DLL Task scheduled problem - 01-30-2004 , 09:16 AM

Re: Activex DLL Task scheduled problem - 01-30-2004 , 02:37 PM