 | |
Setting Boolean Var in Execute SQL task
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Setting Boolean Var in Execute SQL task -
07-29-2008
, 08:52 PM
#2
| |||
| |||
|
|
I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as test I also tried: select 1 as test select 'True' as test REsult Set test mapped to pIsExists Error: Execute SQL Task: An error occurred while assigning a value to variable "pDataExists": "The type of the value being assigned to variable "User:  DataExists" differs from the current variable typeplease help, tia - chris |
statement. Like:
SELECT CAST(0 as bit) as Bool
SELECT CAST('True' as bit) as Bool
Both worked here.
#3
| |||
| |||
|
|
I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as test I also tried: select 1 as test select 'True' as test REsult Set test mapped to pIsExists Error: Execute SQL Task: An error occurred while assigning a value to variable "pDataExists": "The type of the value being assigned to variable "User: DataExists" differs from the current variable typeplease help, tia - chris |
statement. Like:
SELECT CAST(0 as bit) as Bool
SELECT CAST('True' as bit) as Bool
Both worked here.
#4
| |||
| |||
|
|
I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as test I also tried: select 1 as test select 'True' as test REsult Set test mapped to pIsExists Error: Execute SQL Task: An error occurred while assigning a value to variable "pDataExists": "The type of the value being assigned to variable "User: DataExists" differs from the current variable typeplease help, tia - chris |
statement. Like:
SELECT CAST(0 as bit) as Bool
SELECT CAST('True' as bit) as Bool
Both worked here.
#5
| |||
| |||
|
|
I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as test I also tried: select 1 as test select 'True' as test REsult Set test mapped to pIsExists Error: Execute SQL Task: An error occurred while assigning a value to variable "pDataExists": "The type of the value being assigned to variable "User: DataExists" differs from the current variable typeplease help, tia - chris |
statement. Like:
SELECT CAST(0 as bit) as Bool
SELECT CAST('True' as bit) as Bool
Both worked here.
#6
| |||
| |||
|
|
I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as test I also tried: select 1 as test select 'True' as test REsult Set test mapped to pIsExists Error: Execute SQL Task: An error occurred while assigning a value to variable "pDataExists": "The type of the value being assigned to variable "User: DataExists" differs from the current variable typeplease help, tia - chris |
statement. Like:
SELECT CAST(0 as bit) as Bool
SELECT CAST('True' as bit) as Bool
Both worked here.
#7
| |||
| |||
|
|
I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as test I also tried: select 1 as test select 'True' as test REsult Set test mapped to pIsExists Error: Execute SQL Task: An error occurred while assigning a value to variable "pDataExists": "The type of the value being assigned to variable "User: DataExists" differs from the current variable typeplease help, tia - chris |
statement. Like:
SELECT CAST(0 as bit) as Bool
SELECT CAST('True' as bit) as Bool
Both worked here.
#8
| |||
| |||
|
|
I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as test I also tried: select 1 as test select 'True' as test REsult Set test mapped to pIsExists Error: Execute SQL Task: An error occurred while assigning a value to variable "pDataExists": "The type of the value being assigned to variable "User: DataExists" differs from the current variable typeplease help, tia - chris |
statement. Like:
SELECT CAST(0 as bit) as Bool
SELECT CAST('True' as bit) as Bool
Both worked here.
#9
| |||
| |||
|
|
I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as test I also tried: select 1 as test select 'True' as test REsult Set test mapped to pIsExists Error: Execute SQL Task: An error occurred while assigning a value to variable "pDataExists": "The type of the value being assigned to variable "User: DataExists" differs from the current variable typeplease help, tia - chris |
statement. Like:
SELECT CAST(0 as bit) as Bool
SELECT CAST('True' as bit) as Bool
Both worked here.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.