DTSDestination not defined !!!!!

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

DTSDestination not defined !!!!!

Author

Topic

probole
Starting Member

3 Posts

Posted - 2006-12-26 : 16:13:16

Hi, i'm a beginner in DTS / Activex , in SQL Server 2000.

I need to update 500.000 records of a TableB (containing 2.000.000 rows) with a TableA (containing 500.000 rows)

With Enterprise Manager I made a new DTS package (my first package!)

I define / drag 2 Connections as OLE (the first-right icon)
(but i don't define any Activities as dts. Then i define the following ActiveX (VBs) :

Function Main()

if DTSDestination("NDG") = (DTSSource("NDG")) THEN

DTSDestination("BANCA") = DTSSource("BANCA")
DTSDestination("NDG") = DTSSource("NDG")
'Pao: LA LOGICA DELLA TRASFORMAZIONE
if (DTSSource("PTF")) > 0 THEN
IF (DTSSource("SEGMENTO")) > 0 THEN
DTSDestination("CAMPO_N1") = DTSSource("SEGMENTO")
DTSDestination("PTF_CLIENTE_OLD") = DTSSource("PTF")
ELSE
DTSDestination("CAMPO_N1") = DTSDestination("SEGMENTO_CLIENTE")
DTSDestination("PTF_CLIENTE_OLD") = DTSSource("PTF")
END IF
ELSE
IF (DTSSource("SEGMENTO")) > 0 THEN
DTSDestination("CAMPO_N1") = DTSSource("SEGMENTO")
DTSDestination("PTF_CLIENTE_OLD") = 0
ELSE
DTSDestination("CAMPO_N1") = DTSSource("SEGMENTO")
DTSDestination("PTF_CLIENTE_OLD") = DTSSource("PTF")
END IF
END IF
END IF
Main = DTSTransformStat_OK

End Function

+++++++++++

but when I run it I obtain the following error message: DTSDestination not defined, idem for DTSSource.

Please help me, it's IMPORTANT !

Thank You.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-12-26 : 16:22:11

Please do not cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76840

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources