|
Home > Archive > MS SQL Server DTS > September 2005 > SourceObjectName empty
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SourceObjectName empty
|
|
|
| I’m trying to create an audit table for my data warehouse.
As part of it, I wanted to add code to get the task properties and
load them into a table, but the following comes back empty:
msgbox(objTask.SourceObjectName)
Any idea why?
There is a valid SourceConnectionID, and a valid Source SQL that comes
back using the same msgbox (but with the appropriate property).
Thanks
Nile
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/DTS-SourceO...pict258875.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=892552
| |
| Allan Mitchell 2005-09-28, 3:24 am |
| So what is objTask?
I will presume a DataPump task.
How does the rest of your code look?
Anything like this?
dim tsk
set tsk =
DTSGlobalVariables.Parent.Tasks(" DTSTask_DTSDataPumpT
ask_1").CustomTask
MsgBox tsk.SourceObjectName
"Nile" < UseLinkToEmail@dbFor
umz.com> wrote in message
news:4_892552_edda26
6adac9a3f6da0fe3eb99
e2834b@dbforumz.com:
> I’m trying to create an audit table for my data warehouse.
> As part of it, I wanted to add code to get the task properties and
> load them into a table, but the following comes back empty:
> msgbox(objTask.SourceObjectName)
> Any idea why?
> There is a valid SourceConnectionID, and a valid Source SQL that comes
> back using the same msgbox (but with the appropriate property).
> Thanks
> Nile
>
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/DTS-SourceO...pict258875.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=892552
| |
| Darren Green 2005-09-30, 3:23 am |
| Nile wrote:
> I’m trying to create an audit table for my data warehouse.
> As part of it, I wanted to add code to get the task properties and
> load them into a table, but the following comes back empty:
> msgbox(objTask.SourceObjectName)
> Any idea why?
> There is a valid SourceConnectionID, and a valid Source SQL that comes
> back using the same msgbox (but with the appropriate property).
> Thanks
> Nile
>
You will have either SourceObjectName or SourceSQLStatement not both.
That just does not make sense as you cannot run a custom query and
retrieve data from a named table at the same time.
--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
|
|
|
|
|