variable datatype

Question

HI

  i used execute sql task in my package so in that i wrote a query like this

select max(id) as id from dim_table

my id column is in number datatype

i used resultset to get this data

but in that varaible type i choose int32 means

its shows error like this

[Execute SQL Task] Error: An error occurred while assigning a value to variable "ID": "The type of the value being assigned to variable "User::ID" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
".

so which datatype i want to choose in my varible

Answer 1

Maybe you can add a CAST in your query:

select CAST(max(id) as int) as id from dim_table

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Answer 2

HI

  i used execute sql task in my package so in that i wrote a query like this

select max(id) as id from dim_table

my id column is in number datatype

i used resultset to get this data

but in that varaible type i choose int32 means

its shows error like this

[Execute SQL Task] Error: An error occurred while assigning a value to variable "ID": "The type of the value being assigned to variable "User::ID" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
".

so which datatype i want to choose in my varible

You use SingleRow option as you are getting only one value which is Max

Murali

Answer 3

Ya i tried that still i m getting that same error..

Answer 4

You have 2 options:

1. If you want output in resultset then you need to use Object datatype in variables.

2. You can use Stored proc and in that use the ID variable as Output Parameter. Set the Variables as number datatype and you will not get any error.

Let me know if you still faces the issue after you made the changes.

Answer 5

Shall i explain me  briefly

Answer 6

The resultset option in the General tab should be SingleRow. Kindly check it

Answer 7

Ya i tried that still i m getting that same error..

What's your result set type? (See general tab)

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Answer 8

Ya that's in Single row only then only result set window will enable..

Answer 9

Ya that's in Single row only then only result set window will enable..

It should work. Not sure what could be the problem. Let's see if somebody else has better solutions.

Murali

Answer 10

ya thanks for all... in that general tab  bypassprepare i set as false now its working very thanks for ur reply's