I made some test and it work, but not for a string return:
I change the stored proc to this:
ALTER PROCEDURE [dbo].[uspGetConfigParamValue]
@ParameterValueVar int OUTPUT
SET NOCOUNT ON;
SET @ParameterValueVar = 55
and I change the Execute task to this:
I declare the 4 variables in the parameter mapping, and I use the same name as in the stored Proc(see http://www.juliankuiters.id.au/artic...put-parameters
), like @ParameterValueVar map to MyFile as a Int32 (for the purpose of testing). So I have also 4 variables in the package (MyFile as Int32, MyApp, MyParm and MyType as String).
Now, I change the expression for the connection as:
"C:\\Test" + (DT_STR, 2, 1252) @[User::MyFile] + ".txt"
and it work, it change the name of the file. But when I try to use string type, it give me the same error (data type invalide). So I think that maybe the String type of the variable at the package level is not compatible with the string type in the ADO.NET connection.