• To add further to my confusion - I just checked the table the the parameters are linked to and it would appear the sql task container, is doing what I intend it to do

    using the OLEDB connection, with Direct Input and the following command

    [font="Courier New"]admin.up_SetLogicalDate null, ?, ?, ?[/font]

    Also, the parameters were mapped as Ordinals, with null defined for the sp input @QueryDate

    Parameter Mapping

    User::LogicalDate Output Date 0 -1

    User::LogicalDate Output Date 1 -1

    User::LogicalDate Output Date 2 -1

    .........but still I get the the error

    [font="Courier New"]

    [Execute SQL Task] Error: Executing the query "admin.up_SetLogicalDate null, ?, ?, ?" failed with the following error: "Error HRESULT E_FAIL has been returned from a call to a COM component.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    [/font]

    Any clues, anyone????????????????

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)