Hi I am new to SSIS.

While creating the example package given in Chapter 6 Page 148 - Using SQL output Paramteres to Change Runtime settings

The package failed at the Excute Sql task. The error recieved was

Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "EXEC usp_GetConfigParamValue 'MYAPP', 'MYPARM', 'STRING', @MYVALUE OUTPUT" failed with the following 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

I downloaded the source code and ran the package. Same error.

Any clues??

Any help well be appreciated.

Thanks

Regards

Sid

Hi,

Even I'm facing the same problem. Were you able to resolve this error.

Thanks

Hey, this will resolve the issue ..try this

In the Execute SQL Task Editor do the following:
1) General -> Change the ConnectionType to OLEDB
2) General -> Change the SQLStatement to EXEC usp_GetConfigParamValue 'MYAPP', 'MYPARM', 'STRING'
3) General -> Change the ResultSet to Single row
4) Parameter Mapping -> Remove all parameter mapping
5) Result Set -> Add a Result Name of MYFILENAME with a Variable Name of User::MyFile

Finally, change the sproc to the following:
ALTER PROC dbo.usp_GetConfigParamValue(
    @ApplicationName VARCHAR(30),
    @ParameterName VARCHAR(50),
    @ParameterTypeName VARCHAR(30)
)
AS
SET NOCOUNT ON
SELECT 'C:\Execute SQL Sample Changed.txt' AS MYFILENAME
SET NOCOUNT OFF

Thank you very much! That worked for me.