can I get the Parent task in a custom data flow task?

Hot Topic

Remove RS Server from Web Farm Setup SQL 2005
can't modify stored proc which is in a publication
All data has been changed to gobbledygook in my DB
Script generation for Objects - Management Studio
Importing Data From a Flat File
Output in Firefox
Can't Edit Table
SQL 2000 and 2005 on the same cluster
Can you have multiple RS2005 instances running on Server 2003?
sys.conversation_endpoints

SQL Server

multiple columns in "in" search
Bulk Insert Unicode
Permissions using CLR triggers
How can i get data from DataReader Destination?
List all your connection managers
Stored proc, strange error
restore database from CTP edition to developer edition
SQL Server Management Studio Express CTP - not working
Can not attach SQL Server 2005 Express database
since uninstall of ADAM service does not start anymore

can I get the Parent task in a custom data flow task?

I'm building a custom data flow task to handle errors in a generic way in C#. I want to output the Task name (the name of the Data flow) as well as the Task name that is inputting data into my custom task.        

Is there a way to get both the task name and the previous data flow task name that's inputting the data

THanks in advance,
-Chris

PS, the VariableContainer didn't seem to contain any of the system variables- ex. the below statement returned false.

this.VariableDispenser.Contains("System::SourceName")

Answer this question

can I get the Parent task in a custom data flow task?

  • WASTHEBEST

     Matt David wrote:
    As I mentioned in my original post, there is no such system variable.  You can look in the designer to see all the system variable that are available.

    Matt


    Just to clarify Matt's point...SSIS actually does have a System::SourceName variable but it is only available in the eventhandler container. You can't reference it in your control-flow.

    -Jamie


  • Carlosmcg

    I believe you can get hold of the component next to it in the flow, by looking at one of the input collections. However you can't find out the component that added a column to a flow.

  • Blutcher

    As I mentioned in my original post, there is no such system variable.  You can look in the designer to see all the system variable that are available.

    Matt

  • sondlerd

    I added the System::SourceName variable to the custom data flow component by using LockOneForWrite, but gave an error that that variable doesn't exist.

    Is there a place where I can find a listing of the system variables available at the data flow component level


  • DveMac

    I am talking about a dataflow component.

    Do I have to add the system variables to the VariableDispenser

    Thanks for your help Matt,
    -Chris

  • Martin Drinovsky

    Yes, you have to add all variables to the variable dispenser in the form of the lock methods.  Otherwise the variable dispenser is empty.

    Matt

  • gishac

    Are you talking about a control flow task or a data flow component   For a dataflow component you can not get any information about any other component other than yourself.

    As for the variable dispenser, unless you have added variables to it via the lock methods then it contains no variables.  Additionally, there is no such system variable as SourceName.

    Thanks,
    Matt

  • can I get the Parent task in a custom data flow task?
Answer this question