I had to alter some VFP fields as the SQL counterpart tables had the VFP Date fields defined as varchar! Eeeks...
Gil Sent via BlackBerry by AT&T -----Original Message----- From: Paul Hill <paulroberth...@gmail.com> Date: Wed, 18 Mar 2009 19:37:26 To: <profoxt...@leafe.com> Subject: Re: SQLServer 2005 reading VFP v-7 tables (in .dbc) 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. Report [OT] Abuse: http://leafe.com/reportAbuse/17cad13c0903181237q21ac3cf4m3b3f8af9a1523...@mail.gmail.com _______________________________________________ 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/1536043533-1237435691-cardhu_decombobulator_blackberry.rim.net-13355985...@bxe1032.bisx.prod.on.blackberry ** 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.
