Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

DTD Error Handler

 
   Database Forums (Home) -> DTS RSS
Next:  mt_rand question  
Author Message
Jean

External


Since: Nov 19, 2008
Posts: 1



(Msg. 1) Posted: Wed Nov 19, 2008 8:59 am
Post subject: DTD Error Handler
Archived from groups: microsoft>public>sqlserver>dts (more info?)

Hi,
I am trying performing a migration some data of an Oracle database to
another Oracle database using the DTS, but when something occurs wrong
my script stop.

Looking at ActiveX Script I am try:

Function Main()

On Error Goto LocalHandler

DTSDestination("TEXTO") = DTSSource("TEXTO")
DTSDestination("NUMERO") = DTSSource("NUMERO")
Main = DTSTransformStat_OK

Exit Function

LocalHandler:

‘After this test I will log the error, etc…
Resume Next

End Function

But when I run it appear an error inform syntax error at line 2.

Someone now what can I do in this case?
Thanks.

 >> Stay informed about: DTD Error Handler 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> DTS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]