I need to check whithin an exists DTS source fild, i have the next code VB,
but it made error message is " No match the types : 'exists' "

Any help will be great
Thank you.

'************************************************* *********************
' Secuencia de comandos de transformacin Visual Basic
'************************************************* ***********************

' Copia cada columna de origen a la columna de destino

Function Main()

If exists (DTSSource("Col004")) Then
DTSDestination("Campo04") = DTSSource("Col004")
end if

DTSDestination("Campo03") = DTSSource("Col003")
DTSDestination("Campo02") = DTSSource("Col002")
DTSDestination("Campo01") = DTSSource("Col001")

Main = DTSTransformStat_OK

End Function

Hi Fernando,

I don't think "exists" is a valid VB function. My VB is a bit rusty,
but in .Net you need to use the File.Exists() to check whether a file
is there.

Good luck!
J

Hi Fernando,

I don't think "exists" is a valid VB function. My VB is a bit rusty,
but in .Net you need to use the File.Exists() to check whether a file
is there.

Good luck!
J

Hi Fernando,

I don't think "exists" is a valid VB function. My VB is a bit rusty,
but in .Net you need to use the File.Exists() to check whether a file
is there.

Good luck!
J

Hi Fernando,

I don't think "exists" is a valid VB function. My VB is a bit rusty,
but in .Net you need to use the File.Exists() to check whether a file
is there.

Good luck!
J

Hi Fernando,

I don't think "exists" is a valid VB function. My VB is a bit rusty,
but in .Net you need to use the File.Exists() to check whether a file
is there.

Good luck!
J

Hi Fernando,

I don't think "exists" is a valid VB function. My VB is a bit rusty,
but in .Net you need to use the File.Exists() to check whether a file
is there.

Good luck!
J

Hi Fernando,

I don't think "exists" is a valid VB function. My VB is a bit rusty,
but in .Net you need to use the File.Exists() to check whether a file
is there.

Good luck!
J

Hi Fernando,

I don't think "exists" is a valid VB function. My VB is a bit rusty,
but in .Net you need to use the File.Exists() to check whether a file
is there.

Good luck!
J

Fernando.

IsNull is the function that should be used.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/