Hi,
I am trying to retrive the info (SQL Statement) from a data pump task.
But i got an error It said "Object doesn't support this property or method"
Am i MISSING something

Dim tsk
Dim resul
Set tsk = DTSGlobalVariables.parent
Set resul = tsk.tasks("DTSTask_DTSDataPumpTask_1")
msgbox resul.SourceSQLStatement
'hi.SourceSQLStatement = "Select * from customer"

Thanks a lot
Ed

Have a look here

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


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

it works...
then I would like to know why sometimes I need to use .customtask, sometimes
i don't

Ed

"Allan Mitchell" wrote:

it's the class specific properties of the task.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


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