Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Anand.A
Posting Yak Master
109 Posts |
 Posted - 2012-02-29 : 00:14:57
|
| HI i used execute sql task in my package so in that i wrote a query like thisselect max(id) as id from dim_tablemy id column is in number datatypei used resultset to get this databut in that varaible type i choose int32 meansits 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 varibleanand |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-02-29 : 03:33:12
|
There is no datatype NUMBER in SQL Server.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-29 : 11:58:38
|
| is it sql server source you're connecting to in execute sql task?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
ssis execute sql task