Hello!

Who can tell me the property name of source and target of a
DTS-Datapumptask?

Like that:

exec sp_OAGetProperty @pkg, 'Tasks("DTSTask_DTSDataPumpTask_1")',@tsk OUT
exec sp_OAGetProperty @tsk, '<name of property>', @tskdest OUT,

where is <name of property> the source (or target) name of the task.

"DestinationObjectName" and "SourceObjectName" does not work.


Thanks!

greets

chris

Have you tried

exec sp_OAGetProperty @pkg,
'Tasks("DTSTask_DTSDataPumpTask_1").CustomTask',@t sk OUT

Then use the DestinationObjectName and SourceObjectName

i.e.

EXEC @hr = sp_OAGetProperty @DTSPkg,
'Tasks("DTSTask_DTSDataPumpTask_1").CustomTask',@t ask OUT
EXEC @hr = sp_OAGetProperty @task, 'SourceObjectName',@sObjectName OUT

Print 'Object Name is ' + @sObjectName

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <abc (AT) def (DOT) de> wrote

Hello,
thanks for the answer! It works fine.........

Executing the DTS package via exec sp_OAMethod @pkg,'Execute' also works.

But the Datapump task does nothing........!

do i have to set the transformations again, or can this be done by "auto
assign"?

greets

chris

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:%23aPS4IxlDHA.2268 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Make sure you are pumping it to where you think. (Check any previous
locations)
If the Destination/Source structures are the same regardless of whether you
changed their locations it should be fine.
If the structures are not the same then you will not be able to do a dynamic
"Auto map"

Allan

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <abc (AT) def (DOT) de> wrote

Hi!
The structures are the same.

But the transformations count is always the same, when source and
destination are changed.

How can i do a "auto map" via TSQL?

greets

chris

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:eKRGFj7lDHA.976 (AT) tk2msftngp13 (DOT) phx.gbl...

If the structures are the same and the column names are the same then you
shouldn't need to remap at all.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <abc (AT) def (DOT) de> wrote

The structures AND the column names are identical,
but the task does nothing.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:eMXVzV8lDHA.3288 (AT) tk2msftngp13 (DOT) phx.gbl...

Have you got logging enabled on the Data Pump task. This would tell you if
the task actually fires (Also do this at the package level so you know it
fired also)

You can then use an AX Script after the datapump to log the amount of rows
that were transformed.

dim pkg
dim tsk
dim iRows

set pkg = DTSGlobalVariables.Parent
set tsk = pkg.Tasks("Name of Task").CustomTask

iRows = tsk.RowsComplete



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <abc (AT) def (DOT) de> wrote