Logging from ActiveX script

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "ArchieM" <mukherjee.archan@xxxxxxxxx>
Date: 10 Oct 2006 00:16:47 -0700

I am Using Active X script task in the SSIS of SQL server 2005 along
with other tasks but I am
not able to log explicitly from this task to the DTS log file where
every other task logs .

when I am trying to log explicitly from it , all characters are coming
as boxes in the
DTS log file .

Can you please help me in logging from the ActiveX script Task to the
DTS log file properly.
It is very much needed.

Thanks in Advance.

.

Prev by Date: RE: Edit SQL 2000 DTS package from SQL 2005
Next by Date: Re: Advice sought on use of DTS [Long]
Previous by thread: Re: SQL2005 and DB2
Next by thread: Text File Manipulation in ActiveX
Index(es):
- Date
- Thread

Relevant Pages

Re: parameter based on a query
... Same AX script task plug that into the statement for the DataPump task. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > The parameter needs to be: SELECT DISTINCT customer FROM <localDB> ... > statement using global variable with an ActiveX Script Task. ...
(microsoft.public.sqlserver.dts)
Re: Calling a stored procedure from Activex Script
... Then use Workflow to determine if that task should run or not ... Alternatively you could just use ADO inside the Active X Script task. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > Activex Script. ...
(microsoft.public.sqlserver.dts)
Re: XML from DTS Tranform task
... Using ADO & with an active X script task was the only way I could get it to ... >>I'm trying to use a DTS transform task to output the results of a query ... The only workable solution is to use ADO. ... > You can wrap the ADO in an ActiveX Script Task to fit it into DTS. ...
(microsoft.public.sqlserver.dts)
Re: remove TXT file using DTS package
... You can do this using the File System Object (FSO) inside an ActiveX ... script task. ... for the basics of how to use ActiveX tasks - it also has examples ...
(microsoft.public.sqlserver.dts)