 | |
Active X Script Error
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Active X Script Error -
04-24-2008
, 08:06 AM
#2
| |||
| |||
|
|
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that would allow me to do this: DTSDestination("columnName") = DTSGlobalVariables("GlobalVariableName").Value I've set up a global variable in the DTS called Test (it's of type int) and given it a value of "3" and created a new Active X transforation for my destination column. However when i run the DTS i get an error saying my function has "returned an invalid DataTransformStatus or an Active X script did not return an integral type" What wrong? |
#3
| |||
| |||
|
|
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that would allow me to do this: DTSDestination("columnName") = DTSGlobalVariables("GlobalVariableName").Value I've set up a global variable in the DTS called Test (it's of type int) and given it a value of "3" and created a new Active X transforation for my destination column. However when i run the DTS i get an error saying my function has "returned an invalid DataTransformStatus or an Active X script did not return an integral type" What wrong? |
#4
| |||
| |||
|
|
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that would allow me to do this: DTSDestination("columnName") = DTSGlobalVariables("GlobalVariableName").Value I've set up a global variable in the DTS called Test (it's of type int) and given it a value of "3" and created a new Active X transforation for my destination column. However when i run the DTS i get an error saying my function has "returned an invalid DataTransformStatus or an Active X script did not return an integral type" What wrong? |
#5
| |||
| |||
|
|
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that would allow me to do this: DTSDestination("columnName") = DTSGlobalVariables("GlobalVariableName").Value I've set up a global variable in the DTS called Test (it's of type int) and given it a value of "3" and created a new Active X transforation for my destination column. However when i run the DTS i get an error saying my function has "returned an invalid DataTransformStatus or an Active X script did not return an integral type" What wrong? |
#6
| |||
| |||
|
|
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that would allow me to do this: DTSDestination("columnName") = DTSGlobalVariables("GlobalVariableName").Value I've set up a global variable in the DTS called Test (it's of type int) and given it a value of "3" and created a new Active X transforation for my destination column. However when i run the DTS i get an error saying my function has "returned an invalid DataTransformStatus or an Active X script did not return an integral type" What wrong? |
#7
| |||
| |||
|
|
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that would allow me to do this: DTSDestination("columnName") = DTSGlobalVariables("GlobalVariableName").Value I've set up a global variable in the DTS called Test (it's of type int) and given it a value of "3" and created a new Active X transforation for my destination column. However when i run the DTS i get an error saying my function has "returned an invalid DataTransformStatus or an Active X script did not return an integral type" What wrong? |
#8
| |||
| |||
|
|
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that would allow me to do this: DTSDestination("columnName") = DTSGlobalVariables("GlobalVariableName").Value I've set up a global variable in the DTS called Test (it's of type int) and given it a value of "3" and created a new Active X transforation for my destination column. However when i run the DTS i get an error saying my function has "returned an invalid DataTransformStatus or an Active X script did not return an integral type" What wrong? |
#9
| |||
| |||
|
|
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that would allow me to do this: DTSDestination("columnName") = DTSGlobalVariables("GlobalVariableName").Value I've set up a global variable in the DTS called Test (it's of type int) and given it a value of "3" and created a new Active X transforation for my destination column. However when i run the DTS i get an error saying my function has "returned an invalid DataTransformStatus or an Active X script did not return an integral type" What wrong? |
|
« 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.