ActiveX Scripts

#1

I am new to scripting and ActiveX Scripts in DTS
I am getting a syntax error on line 11 and it looks like the example from
MSDN 'Using ActiveX Scripts in DTS'. Can anyone tell me why? Here is my
script:

Function Main()
Pass = DTSSource("PassID")
Select Case Pass
Case "6"
DTSDestination("TripType")=1
Case "7"
DTSDestination("TripType")=2
Case Else
DTSDestination("TripType")=<null>
End Select
Main = DTSTransformStat_OK
End Function

#2

Try replacing <null> with null.

Francesco Anti

"JD" <JD (AT) idfg (DOT) idaho.gov> wrote

Quote:

I am new to scripting and ActiveX Scripts in DTS
I am getting a syntax error on line 11 and it looks like the example from
MSDN 'Using ActiveX Scripts in DTS'. Can anyone tell me why? Here is my
script:

Function Main()
Pass = DTSSource("PassID")
Select Case Pass
Case "6"
DTSDestination("TripType")=1
Case "7"
DTSDestination("TripType")=2
Case Else
DTSDestination("TripType")=<null
End Select
Main = DTSTransformStat_OK
End Function

#3

Thanks

jd

"Francesco Anti" <fanti_ (AT) _sicosbt (DOT) it> wrote

Quote:

Try replacing <null> with null.

Francesco Anti

"JD" <JD (AT) idfg (DOT) idaho.gov> wrote in message
news:%23Xye1T0dFHA.3040 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
I am new to scripting and ActiveX Scripts in DTS
I am getting a syntax error on line 11 and it looks like the example from
MSDN 'Using ActiveX Scripts in DTS'. Can anyone tell me why? Here is my
script:

Function Main()
Pass = DTSSource("PassID")
Select Case Pass
Case "6"
DTSDestination("TripType")=1
Case "7"
DTSDestination("TripType")=2
Case Else
DTSDestination("TripType")=<null
End Select
Main = DTSTransformStat_OK
End Function

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ActiveX Scripts

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

ActiveX Scripts - 06-22-2005 , 11:12 AM

Re: ActiveX Scripts - 06-22-2005 , 11:28 AM

Re: ActiveX Scripts - 06-22-2005 , 11:45 AM