• HI Steveb..

    YEs i want to return a binary data type,i did like what you said it is throwing error...

    [Execute SQL Task] Error: Executing the query "EXEC GetLastLSN @Tablename=?,@LastLSN=? OUTPUT;" failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    My Package variable is

    Tablename,

    Regards..
    guru12