Hi All,

I have a script component in my Dataflow that generates Error Description string.

But I am not trying to convert anything in my Script as you can see below.

Here is the Code inside the SCR_component.

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

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper


Public Class ScriptMain
    Inherits UserComponent
    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
     'Use the incoming error number as a parameter to GetErrorDescription
    Row.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

Hi

Im receiving a strange error Error Message: Conversion from string "15/08/2010 22:21:35" to type 'Date' is not valid.

I know this is generally down to cultural date formats etc, however the reason this is strange is it just randomly occured twice in the last week, the website has been running since october and nothing has changed,

The error constantly occured until the IIS was reset and recompilled the site, its been running fine since, however im just trying to figure out what could cause such an error to occur.

I've narrowed it down to a line of code which is:

bktime = DReader.Item("Bktime").ToString

bktime = Year(CDate(bktime)) & "-" & fmt(Month(CDate(bktime)), 2) & "-" & fmt(Day(CDate(bktime)), 2)

Has anyone else encountered this randomly occuring and is there anything i can put in place to prevent this in future?


Cheers


Mike

I am getting the below error. Please see my code below and let me know what is wrong.

dim sDatetime as string = startdate & " " &starttime & "AM"

dim dt as Date = CDate(sDatetime)

I am getting the Conversion from string "09/28/10 9.00AM" to type 'Date' is not valid error in this line. 

help i am getting error :

Conversion from type 'DBNull' to type 'String' is not valid

Dim OledbString As String = ("SELECT  Product_Hierarchy,Model,Origin,Item_Code,Description,Price_USD FROM [sheet1$]")
                    'Dim eAdapter As New SqlDataAdapter(sqlString, connection)
                    Dim eAdapter As New OleDbDataAdapter(OledbString, connection)
                    Dim eTable As New DataTable()
                    eAdapter.Fill(eTable)

Dim i As Integer = 0
                    While (i < eTable.Rows.Count)
                        If ((eTable.Rows(i)(0)).ToString().Tri

Hi Guys,

I have the following IF Statement checking if the function GetNexstAddress (which gets the ClientID from  GetClientFleetInfo(i).CLIENTID) . SECONDARYCITY

is there.

If GetNextAddress(GetClientFleetInfo(i).CLIENTID).SECONDARYCITY(0) = Nothing Then
                    NextAddress = " No next Destination"
                Else
                    NextAddress = GetNextAddress(GetxxxxFleetInfo(i).TNO).CITY(0)
                End If

somehow I get the error.

+exception{"Conversion from string "111 AA BB" to type 'Integer' is not valid."}System.Exception

Do you have any idea how to fix this?

PS: I have searched through the forum but not found an answer yet.

 Polynaux
 

Msg 241, Level 16, State 1, Line 8
Conversion failed when converting date and/or time from character string.

declare @itemID varchar(20)
declare @startdt varchar(12)
declare @enddt varchar(12)
set @itemID = ''
set