DTS Wizard & NULL datetime,memo fields

Article View: alt.comp.databases

Article #41

Back to alt.comp.databases Previous Next

#41

From: Dan G
Date: Wed, 18 Aug 1999 00:00

38 lines
2711 bytes

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)

Technical Details

Message-ID: <7pedu5$5sn$1@pollux.ip-plus.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb9aa,581c2e3340e0a7da,start
X-Google-Attributes: gidfb9aa,public
X-Google-Thread: f816f,581c2e3340e0a7da,start
X-Google-Attributes: gidf816f,public
X-Google-Thread: 104de1,581c2e3340e0a7da,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,581c2e3340e0a7da,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 107d2f,581c2e3340e0a7da,start
X-Google-Attributes: gid107d2f,public
X-Google-Thread: 1139e2,581c2e3340e0a7da,start
X-Google-Attributes: gid1139e2,public
X-Google-Thread: fc874,581c2e3340e0a7da,start
X-Google-Attributes: gidfc874,public
X-Google-Thread: 10a90d,581c2e3340e0a7da,start
X-Google-Attributes: gid10a90d,public
From: "Dan G" <Gavrilescu.Daniel@pmintl.ch>
Subject: DTS Wizard & NULL datetime,memo fields
Date: 1999/08/18
Message-ID: <7pedu5$5sn$1@pollux.ip-plus.net>
X-Deja-AN: 514212291
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: news@ip-plus.net
X-Trace: pollux.ip-plus.net 934984453 6039 194.209.91.2 (18 Aug 1999 13:54:13 GMT)
Organization: Swisscom IP+ (post doesn't reflect views of Swisscom)
NNTP-Posting-Date: 18 Aug 1999 13:54:13 GMT
Newsgroups: alt.comp.databases,bit.databases,bit.databases.mssql-l,comp.databases.ms-sqlserver,microsoft.public.sqlserver,microsoft.public.sqlserver.clients,microsoft.public.sqlserver.connect,microsoft.public.sqlserver.misc,microsoft.public.sqlserver.odbc,mi