Public Class ScriptMain
Inherits UserComponent
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
'Use the incoming error number as a parameter to GetErrorDescriptionRow.ErrorDescription = ComponentMetaData.GetErrorDescription(Row.ErrorCode)
End Sub
End Class

-------------------------------------------------

When I run the package , it fails at this script task with the following error:

Description: System.InvalidCastException: Conversion from string "C002" to type 'Integer' is not valid.

The value "C002" is actually a column in the metadata and its type is "DT_STR". I am not trying to convert it in my Script as you can see

I have the following function, sometimes I want to pass a DBNULL.Value to the function so I update the database with a null value, but it won't let me as the DBNULL.Value is not a string or an integer, how can I get this to work?

Public Function Testing (ByVal FirstString as String, ByVal FirstInteger as Integer), how to pass a DBNULL.Value?
' update database
Return value
End Function

Hi I have been trying unsuccssfully to convert a column of data (mycolumn) from a table (mytable) that has ascii character strings comprised of characters numbered from 0-255. I need to be able to group the numeric values for each ascii string
from each record, into what I call an integer group and write that value back to a different column for each respective record in the table. But, I can't figure out how to modify the following Microsoft code to perform this:

SET TEXTSIZE 0
SET NOCOUNT ON
-- Create the variables for the current character string position
-- and for the character string.
DECLARE @position int, @string char(15)
-- Initialize the variables.
SET @position = 1
SET @string = 'Du monde entier' --here I don't know how to pass a selected column to the @string
WHILE @position <= DATALENGTH(@string) --here I need to know how to loop through each records ascii string and group the values
BEGIN
SELECT ASCII(SUBSTRING(@string, @position, 1)),
CHAR(ASCII(SUBSTRING(@string, @position, 1)))
SET @position = @position + 1
END
SET NOCOUNT OFF -- then down here somewhere I need to write each converted string to integers back to the myintegerGroup column
GO

The output from above is below, But I need grouped examp: Du monde entier => 681173210911111010010132101110116105101114

Error at Data Flow Task [Derived Column [46]]: The data types "DT_WSTR" and "DT_I4" are incompatible for binary operator "==". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both
operands need to be explicitly cast with a cast operator.

Error at Data Flow Task [Derived Column [46]]: Computing the expression "[Gender] ==0?"Male":[Gender]==1?"Female":"NA"" failed with error code 0xC0047084. The expression may have errors, such as divide by zero, that cannot be detected at parse time, or there
may be an out-of-memory error.

Im passsing information to a new item in a different list using the create item workflow.

It seems to work from apart from one, critical field. The create item should (i hope) pass a valie from a field 'FIELD' in List A to 'FIELD' in ListB. in list a the field is a lookup from a reference list.

The create new List item workflow ____ it but only returns the type as an integer (an its the oonly option) .

String functions let you extract various portions of character strings, change the case of strings, concatenate and reverse strings and perform many other types of manipulations. All built-in string functions are deterministic with the exception of CHARINDEX and PATINDEX

ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

EncapsulationLet's abstract away the source of the connection string using a class with a static property.

from
the above example i want to extract picture data and need to store in
to the sql table.sql table columname is image and datatype is also
image.after that i wanted to display this image column to an aspx page.