|
Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
|
|
|
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.
|
- Advertisement - |
|||||||||||||||||||||
DTSDestination not defined !!!!!!!!!!!!
Posted - 2006-12-26 : 16:04:39
Hi, i'm a beginner in DTS / ActiveX in SQL Server.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 IFELSE 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 IFEND IF END IFMain = DTSTransformStat_OKEnd 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.
