Error referencing 'DTSStep_DTSExecuteSQLTask_10' Task

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

From: uzoma (uzoma_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 11:08:01 -0700

Hi -
I'm using ActiveX script to load a ExecuteSQL task. Code is as follows:
 Dim oPkg, oDataPump
        Set oPkg = DTSGlobalVariables.Parent
        Set oDataPump = oPkg.Tasks("DTSStep_DTSExecuteSQLTask_10").CustomTask
        oDataPump.SQLStatement = del_qry
        Set oDataPump = Nothing
        Set oPkg = Nothing
        Main = DTSTaskExecResult_Success
I get this error: (Microsoft Data Transformation Services (DTS) Package Task 'DTSStep_DTSExecuteSQLTask_10' was not found) even though I looked up the right name by going to Workflow properties and then options.

I'm doing this on a SQL7 box.
Do you know what else I can do to resolve this error?
Appreciate any help!

Thanks
Uzoma

Relevant Pages

  • Re: Need Example exec proc from VBScript ActiveX DTS.
    ... fool DTS into creating the output variables using "metadata" spoofing. ... I need to integrate global variables in and out of several DTS steps. ... >>> Can you not use an ExecuteSQL task? ... > Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: nightly refresh of a backup table - is it DTS
    ... Add a Transform Data task and simply pipe the rows into the backup table. ... Join from the ExecuteSQL task to the Transform Data task using an "On Success" precedence constraint. ... Building a Package in the DTS Designer ...
    (microsoft.public.sqlserver.dts)
  • Re: help assigning value to global variable
    ... www.SQLDTS.com - The site for all your DTS needs. ... The transform data task takes data form the text ... > How does the ExecuteSQL task assign the value to the global variable? ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Max length of string global variable
    ... IN an ExecuteSQL task did ... www.SQLDTS.com - The site for all your DTS needs. ... > Is there a max length for DTS Global Variables of type string? ... The output parameter is at least 500 ...
    (microsoft.public.sqlserver.dts)