 | |
SSIS,DBF and Deleted Records
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: SSIS,DBF and Deleted Records -
05-02-2008
, 02:55 PM
|
Problem solved, it appears that if you SELECT * FROM <TABLE> it returns deleted records, but if you are explict in your selection then deleted records are not returned. "Andrew Stewart" <andrew.stew... (AT) radcomp (DOT) co.nz> wrote in message news:ex7yoiiqIHA.2520 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have also been imported as valid records. I'm current using the latest VFPOLEDB.1 provider 9.0.0.5815, which I believed by default didn't select deleted records. Trying to reconcile between the VFP application, the dbf file, and the imported data in SQL database, I noticed a number of deleted records. *Is there anyway to set the connection to not show deleted records? Or in the query selecting from the source?- Hide quoted text - - Show quoted text - |
records to be ignored.
#12
| |||
| |||
|
|
Problem solved, it appears that if you SELECT * FROM <TABLE> it returns deleted records, but if you are explict in your selection then deleted records are not returned. "Andrew Stewart" <andrew.stew... (AT) radcomp (DOT) co.nz> wrote in message news:ex7yoiiqIHA.2520 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have also been imported as valid records. I'm current using the latest VFPOLEDB.1 provider 9.0.0.5815, which I believed by default didn't select deleted records. Trying to reconcile between the VFP application, the dbf file, and the imported data in SQL database, I noticed a number of deleted records. *Is there anyway to set the connection to not show deleted records? Or in the query selecting from the source?- Hide quoted text - - Show quoted text - |
records to be ignored.
#13
| |||
| |||
|
|
Problem solved, it appears that if you SELECT * FROM <TABLE> it returns deleted records, but if you are explict in your selection then deleted records are not returned. "Andrew Stewart" <andrew.stew... (AT) radcomp (DOT) co.nz> wrote in message news:ex7yoiiqIHA.2520 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have also been imported as valid records. I'm current using the latest VFPOLEDB.1 provider 9.0.0.5815, which I believed by default didn't select deleted records. Trying to reconcile between the VFP application, the dbf file, and the imported data in SQL database, I noticed a number of deleted records. *Is there anyway to set the connection to not show deleted records? Or in the query selecting from the source?- Hide quoted text - - Show quoted text - |
records to be ignored.
#14
| |||
| |||
|
|
Problem solved, it appears that if you SELECT * FROM <TABLE> it returns deleted records, but if you are explict in your selection then deleted records are not returned. "Andrew Stewart" <andrew.stew... (AT) radcomp (DOT) co.nz> wrote in message news:ex7yoiiqIHA.2520 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have also been imported as valid records. I'm current using the latest VFPOLEDB.1 provider 9.0.0.5815, which I believed by default didn't select deleted records. Trying to reconcile between the VFP application, the dbf file, and the imported data in SQL database, I noticed a number of deleted records. *Is there anyway to set the connection to not show deleted records? Or in the query selecting from the source?- Hide quoted text - - Show quoted text - |
records to be ignored.
#15
| |||
| |||
|
|
Problem solved, it appears that if you SELECT * FROM <TABLE> it returns deleted records, but if you are explict in your selection then deleted records are not returned. "Andrew Stewart" <andrew.stew... (AT) radcomp (DOT) co.nz> wrote in message news:ex7yoiiqIHA.2520 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have also been imported as valid records. I'm current using the latest VFPOLEDB.1 provider 9.0.0.5815, which I believed by default didn't select deleted records. Trying to reconcile between the VFP application, the dbf file, and the imported data in SQL database, I noticed a number of deleted records. *Is there anyway to set the connection to not show deleted records? Or in the query selecting from the source?- Hide quoted text - - Show quoted text - |
records to be ignored.
#16
| |||
| |||
|
|
Problem solved, it appears that if you SELECT * FROM <TABLE> it returns deleted records, but if you are explict in your selection then deleted records are not returned. "Andrew Stewart" <andrew.stew... (AT) radcomp (DOT) co.nz> wrote in message news:ex7yoiiqIHA.2520 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have also been imported as valid records. I'm current using the latest VFPOLEDB.1 provider 9.0.0.5815, which I believed by default didn't select deleted records. Trying to reconcile between the VFP application, the dbf file, and the imported data in SQL database, I noticed a number of deleted records. *Is there anyway to set the connection to not show deleted records? Or in the query selecting from the source?- Hide quoted text - - Show quoted text - |
records to be ignored.
#17
| |||
| |||
|
|
Problem solved, it appears that if you SELECT * FROM <TABLE> it returns deleted records, but if you are explict in your selection then deleted records are not returned. "Andrew Stewart" <andrew.stew... (AT) radcomp (DOT) co.nz> wrote in message news:ex7yoiiqIHA.2520 (AT) TK2MSFTNGP02 (DOT) phx.gbl... Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have also been imported as valid records. I'm current using the latest VFPOLEDB.1 provider 9.0.0.5815, which I believed by default didn't select deleted records. Trying to reconcile between the VFP application, the dbf file, and the imported data in SQL database, I noticed a number of deleted records. *Is there anyway to set the connection to not show deleted records? Or in the query selecting from the source?- Hide quoted text - - Show quoted text - |
records to be ignored.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.