#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    5
    Rep Power
    0

    Question ActiveX DTS Scripts


    Hi all

    trying to ge an activeX task to run in a DTS package.

    Every time i declare something AS somthing, the script says it errors. This is coming from when I press the "Parse" button in the editor window.

    Even something as simple as

    Code:
    Function Main()
    	Dim logColumns As Variant
    End Function
    errors

    Am I missing something here. Its pretty standard VB stuff here. I can't even declare my DTS objects

    Anyone got any pointers?

    Steve
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    2
    Rep Power
    0
    try without the AS argument:

    Function Main()
    Dim logColumns
    End Function

    you don't need to declare what type it is, it'll figure it out based on your content
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    5
    Rep Power
    0
    Is this the same with

    Dim packageItem AS DTS.Package

    ?

IMN logo majestic logo threadwatch logo seochat tools logo