ignore logically deleted records of foxpro db in SSIS
How to ignore logically deleted records in foxpro db from being migrated(using SSIS) to SQL server database? ~Sr. Database Analyst~
June 28th, 2011 11:58am

Use a WHERE clause in your query that fetches data from foxprohttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 12:14pm

Thanks Jamie but... "where clause" on which column as this is logically deleted(internally) in FOX pro DB.No physical column exists that track the logical deletion of the record. ~Sr. Database Analyst~
June 28th, 2011 12:38pm

Hi, I'm afraid you'll have to explain what you mean by logical delete. I took it to mean that you had a column called (e.g.) [IsDeleted] that could be 0(false) or 1(true). http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2011 10:50am

There probably is such a column, or a function called "deleted()" that can be placed in the WHERE clause. Talk to me now on
June 30th, 2011 11:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics