Using SQL Database activity inside composite activity RRS feed

  • Question

  • I want to use the SQL database activity inside a custom composite activity and pass the connection string and other parameters from the parent.  The SQL activity designer class defines a PreFilterProperties method, which is evaluated at design time, and which tests for the existance of the ConnectionString.  If the ConnectionString is hard coded in the SQL activity, everything works as expected.  If the connectionstring is defined as a reference to a property on the parent activity, it is null when the PreFilterProperties is invoked, so the dynamically generated sql properties cannot be defined.

    How can I pass the connectionstring in from the parent while maintaining the dynamic parameter creation as in the PreFilterProperties?

    Friday, March 3, 2006 5:36 PM


  • Unfortunately if you try and retreive the value for a bound property at design time the returned value will be null, even if the bound variable is initialized to a valid value.
    Tuesday, March 7, 2006 10:36 PM