🚀 go-pugleaf

I used DTS Wiz in order to transfer data from FoxPro2.6 .dbf file to SQL 7
table.
I need to give me some tips about how to modify the below script (or the
Basic one) in order to hadle memo filed (i've got the error 'Cannot
instantiate Blobfile') and empty(Null) date fields(i've got the error
'Insert error,... data overflow.Invalid caracter value for cast
specification.').Probably exist something similar with IsNull SQL function.

Thanks in advance,

daniel.

//**********************************************************************
//  Java Transformation Script
//  Copy each source column to the
//  destination column
//************************************************************************

function Main()
{
 DTSDestination("EFF_DATE") = DTSSource("EFF_DATE");
--  EFF_DATE somethime contain empty values
 DTSDestination("WHL_CR2") = DTSSource("WHL_CR2");
--WHL_CR2 is FoxPro memo filed
 return(DTSTransformStat_OK);
}

Source: FoxPro 2.5
Using Microsoft Jet 4.0 OLE DB Provider
Location: Z:\backup\tmp\SYSDATA

Destination: Microsoft SQL Server
Using Microsoft OLE DB Provider for SQL Server
Location: (local)
Database: <my database>

Tables
my table -> [my database].[dbo].[my table] (uses transform)