471,896 Members | 1,639 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,896 software developers and data experts.

Importing data from Pervasive 2000 to SQL Server 2000

I am working on bringing data into our SQL Server from a btreive
database through Pervasive.

It seems to work, mostly, but I am having problems with dates.

At first, all date conversions from btreive field type Date to SQL
Server SmallDateTime would produce nothing but errors of this sort:
ActiveX Scripting Transform 'DTSTransformation_1' encountered and
invalid data value for 'HomesteadDate' source column.

Looking into the data on the pervasive side, many of the the date
fields had no data in them.

I tried to get around this by changing all lines that brought over
dates from this:
DTSDestination("HomesteadDate") = DTSSource("HomesteadDate")

to this:
IF ISDATE(DTSSource("HomesteadDate")) = 1 THEN
DTSDestination("HomesteadDate") = DTSSource("HomesteadDate") ELSE
DTSDestination("HomesteadDate") = NULL

What I have discovered since then, is that all my dates are simply
failing the ISDATE check and returning null to the SQL Server, even
when it is a valid date.

Any suggestions would be greatly appreciated.

Steve Hoyer
GPW, MI
Jul 20 '05 #1
0 2370

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bre-x | last post: by
5 posts views Thread by Chuy | last post: by
reply views Thread by jan82 | last post: by
reply views Thread by jan82 | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.