Post reply

Error: "Invalid Procedure Call or Argument, "DTS Lookups"

  • April 30, 2007 at 6:19 am

    #68657

    Hi all,

    I'm getting an error with a new package containing a lookup - but even if I remove the lookup and try to copy the data across untransformed, I get a

    Error; Type Mismatch: DTS Lookups.

    Anyone know what's happening here?

    Cheers,

     

    Jaybee.

  • April 30, 2007 at 6:28 am

    #703254

    Jaybee,

    I'm afraid you'll have to give us more information than that buddy. Is this a transformation task? From what to what? What does the lookup involve?

    The more info you give, the better we may be able to help.


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • April 30, 2007 at 6:59 am

    #703268

    It's ok...problem resolved...somehow????

    I reloaded the SAME active X script for the lookup, and it decided to work.  Only one thing I hate more than a problem I can't solve - a resolution I can't explain.

    (puts on best Rod Serling voice with eerie background music)

    "You can file this one under 'S' for "SQL Server DTS mysteries that resolve themselves as mysteriously as they first arose" in....the Twilight Zone".

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply