DTS Foxpro to SQL Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS Foxpro to SQL Server

Author

Topic

memarcie
Yak Posting Veteran

91 Posts

Posted - 2006-03-01 : 10:26:47

Hi,
I am running a DTS package to transfer several Foxpro 7.0 dbf's to SQL server. I'm having a problem with dates coming over as null. They contain a valid date when I use the preview function in DTS, however when I actually run the task, the dates show up as null.

Here is an example of the data in SQL Server after the DTS package runs:
ID,Eff date,Term Date
6341,1996-12-01 00:00:00.000,2006-01-31 00:00:00.000
6341,NULL,2006-01-31 00:00:00.000

In preview:
ID,Eff date,Term Date
6341,1996-12-01,2006-01-31
6341,1997-03-01,2006-01-31

In Foxpro:
ID,Eff date,Term Date
6341,12/1/1996,1/31/2006
6341,03/31/1997,1/31/2006

The data type is date in Foxpro and datetime in SQL Server,Any suggestions?

Thanks,
Marcie

memarcie
Yak Posting Veteran

91 Posts

Posted - 2006-03-04 : 21:26:42

Anyone have any suggestions for this?

Thanks,
Marcie

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources