Home Forums SQL Server 2005 SQL Server 2005 Integration Services Use parameters with Execute SQL task RE: Use parameters with Execute SQL task

  • August 25, 2005 at 7:19 pm

    #585249

    I finally got a good answer on this one.  Use '?' as the placeholder in the query and use numbers starting at 0 for the parameter name.  Works like a charm!

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor