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)