View Single Post
  #2 (permalink)  
Old April 18th, 2007, 06:42 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Try this...
Code:
'   Visual Basic ActiveX Script
Function Main()
    dim sql 
    sql = DTSGlobalVariables("CountofRec").Value
    MsgBox sql
    'If sql > 700  Then  <--I get a type mismatch on this line 
        'Main = DTSTaskExecResult_Success 
    'Else
        'Main = DTSTaskExecResult_Failure
    'End If
End Function
And see what it returns.

_________________________
- Vijay G
Strive for Perfection