Jim Horn
asked on
SSIS ScriptTask: How to do UpperCase(StringVariable)
Hi All
In an SSIS Script Task I'm trying to convert a string variable to upper case.
This line --> ConName.ToUpper <> "FRAMEWORK" <-- returns the below compile error
Package Validation Error
-------------------------- ----
ADDITIONAL INFORMATION:
Error at Initialize Connections: The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.
(Microsoft.DataTransformat ionService s.VsIntegr ation)
This line --> UPPER(ConName) <> "FRAMEWORK" <-- returns 'Name 'UPPER' is not declared.
Thanks in advance.
Jim
In an SSIS Script Task I'm trying to convert a string variable to upper case.
This line --> ConName.ToUpper <> "FRAMEWORK" <-- returns the below compile error
Package Validation Error
--------------------------
ADDITIONAL INFORMATION:
Error at Initialize Connections: The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.
(Microsoft.DataTransformat
This line --> UPPER(ConName) <> "FRAMEWORK" <-- returns 'Name 'UPPER' is not declared.
Thanks in advance.
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Paste the Script Task code here so Experts can review. Thanks.