On Wed, Mar 18, 2009 at 5:19 PM, Stephen Russell <srussell...@gmail.com> wrote:
> This is a SSIS job or DTS in sql 2000.
>
> <http://en.wikipedia.org/wiki/SQL_Server_Integration_Services>
>
> This is real simple to do in .NET for working with Sql2005. Notice
> that I said it is not in SQL SSMS. Yes this got loaded when you
> installed SQL2005 but you probably never went to the Business
> Intelligence Development Studio.
>
> There you can connect the dbf to SQL containers. Set up any
> conversions you need.
Many years ago I tried to use DTS to load a bunch of DBF files onto a
SQL server.
The problem I found was that DTS was finicky (rightly so!) about
invalid data. My data was pretty old and started life as a DOS app in
the 80s. Fox will quite happily work with a date like {01/01/0001}
but SQL will reject it.
For this reason I tend to use Fox to 'push' the data to SQL. This way
I can validate the data (including checking for Y2K problems, e.g.
01/01/1902 becomes 01/01/2002). Other considerations might be to
write a NULL if a character field is empty.
It's easy to write a small Fox program that generates CREATE TABLE and
INSERT statements into a text file (with the a 'GO' every 1000 or so
records) and then use isql/osql/sqlapp to execute this SQL batch.
YMMV, in my case I was doing a one way, one time export from Fox.
--
Paul
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/17cad13c0903181237q21ac3cf4m3b3f8af9a1523...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
