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