Post reply

Calling a task or transformation from active x

  • August 9, 2007 at 12:45 pm

    #70591

    Hi, I have a package that has an Active X script that verifies that a file exists in a specific location. When the file is found I need to execute a transformation that imports the data from the file into a table in SQL. As of this point I can detect the file and verify the name of the file. Can some please show me an example of executing a transformation?

    I have looked at SQLDTS.com but nothing there is what I am trying to do.

    Thanks in advance.

    Gary

  • August 10, 2007 at 7:57 am

    #726022

    You don't need to this in ActiveX. You can follow your ActiveX script with a normal datapump between the two connections (file and table). Add in some code, to set the status of the datapump task, to your ActiveX script; if the file is there: execute, if not: don't...

    Example:

    Set oPkg = DTSGlobalVariables.Parent

    Set oStp = oPkg.Steps("MyDataPumpTask")

    'If file exists

       oStp.DisableStep = False

    'Else

       oStp.DisableStep = True


    Ade

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

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

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