RE: ActiveX Script in DTS Package

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tomasz Borawski <TomaszBorawski@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 2 May 2008 07:13:00 -0700

Search ADO and Command Object

"David P." wrote:

I have a DTS package that has the ActiveX Script code listed below that is
used to call stored procedures in SQL Server database. The DTS package and
database correspond to SQL Server 2000.

Please help me find documentation that corresponds to the code listed below.

Thanks,

cmdGetCharCount.parameters.append cmdGetCharCount.createparameter
("@strInPValue",200,1,255)

cmdGetCharCount.parameters.append cmdGetCharCount.createparameter
("@Char",200,1,1)

cmdGetCharCount.parameters.append cmdGetCharCount.createparameter
("@CountOfOcc",3,2,4)

Prev by Date: Re: Enable Memory Restriction for Lookup Transformation
Next by Date: RE: Execute SSIS package from a sql stored procedure
Previous by thread: Document DTS Package
Next by thread: RE: Execute SSIS package from a sql stored procedure
Index(es):
- Date
- Thread

Relevant Pages

ActiveX Script in DTS Package
... I have a DTS package that has the ActiveX Script code listed below that is ... used to call stored procedures in SQL Server database. ... database correspond to SQL Server 2000. ...
(microsoft.public.sqlserver.dts)
DTS Transformation Task Problem
... I am currently trying to put a sql server database table into a txt file by using a dts package. ... I came out with the following problem, the sql server manager gives a fatal error because the source table have to many rows. ... I am querying the table and selecting the desired fieldsand when i go to the transformation properties and make the populate it goes everything wrong the it crashes... ...
(microsoft.public.sqlserver.dts)
Re: How to capture SQL statement messages in DTS log file
... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
(microsoft.public.sqlserver.dts)
Re: export access to sql server
... i followed article from sql server books MSDN. ... Running a DTS Package Saved as a Visual Basic File ... Actually my software will support access ... If the app needs to dynamically recreate the ...
(microsoft.public.vb.general.discussion)
Executing a DTS package from a Web application.
... Can a SQL Server 2000 DTS Package be run from a Web application? ... The SQL Server database is not local. ... Package Execution Lineage: ...
(microsoft.public.sqlserver.dts)