Post reply

Execute SQl Task

  • August 12, 2008 at 2:35 pm

    #192265

    Hi,

    I'm not able to excute my stored proc which returns the output value. It shows the error

    "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 3 ("@MYVALUE"): Data type 0xE7 has an invalid data length or metadata length.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Task failed: Execute SQL Task

    How should I do the parameter mapping and what should be the result name in Result set.

    Thanks

  • August 12, 2008 at 2:59 pm

    #857060

    Try following

    1) Create Variable of the datatype "object"

    2) In Execute sQL task Editor set property to resultset to FullResultSet

    3) In resultset Section,

    1) Resultset Name = 0

    2) VariableNAme =

    With this you will be able to transfer your tabular data in resultset

    (View snapshot for more details)

    Hope this helps 😉

  • August 12, 2008 at 3:05 pm

    #857061

    Hey,

    I'm using ADO.net connection as Connection type....will this work for it, b'coz I received an error while careting the object type variable.

    Thanks

  • August 12, 2008 at 3:44 pm

    #857076

    Use OleDb connection

  • August 12, 2008 at 4:27 pm

    #857083

    Thanks, it solved the problem.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply