I am trying to pass a value from a stored proc output variable to a user
variable in SSIS. When I define the variable as integer in both SSIS and the
stored proc, every thing is fine, however, it gives me a data type mismatch
error when I declare the variable as varchar in stored proc and as STRING in
SSIS.

I have tried every other reasonable combination but nothing seems to work.
How can I pass a string from a stored proc to the SSIS variable?

Hello Jim:
Can you tell us what Task you are using to accomplish this? Is it an Execute
SQL Task? What type of connection does it have? OLE DB or ADO.NET?
How are you setting up the Result Set?
--
Todd C

"Jim" wrote:

Hello Jim:
Can you tell us what Task you are using to accomplish this? Is it an Execute
SQL Task? What type of connection does it have? OLE DB or ADO.NET?
How are you setting up the Result Set?
--
Todd C

"Jim" wrote:

Hello Jim:
Can you tell us what Task you are using to accomplish this? Is it an Execute
SQL Task? What type of connection does it have? OLE DB or ADO.NET?
How are you setting up the Result Set?
--
Todd C

"Jim" wrote:

Hello Jim:
Can you tell us what Task you are using to accomplish this? Is it an Execute
SQL Task? What type of connection does it have? OLE DB or ADO.NET?
How are you setting up the Result Set?
--
Todd C

"Jim" wrote:

Hello Jim:
Can you tell us what Task you are using to accomplish this? Is it an Execute
SQL Task? What type of connection does it have? OLE DB or ADO.NET?
How are you setting up the Result Set?
--
Todd C

"Jim" wrote:

Hello Jim:
Can you tell us what Task you are using to accomplish this? Is it an Execute
SQL Task? What type of connection does it have? OLE DB or ADO.NET?
How are you setting up the Result Set?
--
Todd C

"Jim" wrote:

Hello Jim:
Can you tell us what Task you are using to accomplish this? Is it an Execute
SQL Task? What type of connection does it have? OLE DB or ADO.NET?
How are you setting up the Result Set?
--
Todd C

"Jim" wrote:

Hello Jim:
Can you tell us what Task you are using to accomplish this? Is it an Execute
SQL Task? What type of connection does it have? OLE DB or ADO.NET?
How are you setting up the Result Set?
--
Todd C

"Jim" wrote:

Hi Todd!

I just have the same problem. I call a stored procedure. I assign the value
of a Guid to a varchar(50) variable and at last I perform a SELECT to pass it
to the variable of SSIS. I use an Execute SQL Task and the variable of SSIS
is a string. With integer it works all right, but with varchar(50) there is
no way to make it work. Code of the stored proc is something like this

DECLARE @IDTipoArchivoFotografia varchar(50)

SET @IDTipoArchivoFotografia = NEWID()

SELECT @IDTipoArchivoFotografia AS IDTipoArchivo

and the error
The type of the value being assigned to variable "User::IDTipoArchivo"
differs from the current variable type

thanks,

Joan




"Todd C" wrote: