Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Job
Yak Posting Veteran
69 Posts |
 Posted - 2006-04-26 : 07:22:53
|
| I am using bcp with a format file. I'm testing on a small data set, but not all of the data is imported. here is the format file contents;9.0491 SQLCHAR 0 255 "|\"" 1 First ""2 SQLCHAR 0 255 "\"|\"" 2 InvNum ""3 SQLCHAR 0 255 "\"|\"" 3 InvSvDt ""4 SQLCHAR 0 255 "\"|\"" 4 InvCrDt ""5 SQLCHAR 0 255 "\"|\"" 5 InvCrIDXPd ""6 SQLCHAR 0 255 "\"|\"" 6 InvOrigFSCNum ""7 SQLCHAR 0 255 "\"|\"" 7 InvOrigFSCNme ""8 SQLCHAR 0 255 "\"|\"" 8 InvOrigFSCRptCat1Nme ""9 SQLCHAR 0 255 "\"|\"" 9 InvOrigFSCRptCat2Nme ""10 SQLCHAR 0 255 "\"|\"" 10 InvCurrFSCNum ""11 SQLCHAR 0 255 "\"|\"" 11 InvCurrFSCNme ""12 SQLCHAR 0 255 "\"|\"" 12 InvCurrFSCRptCat1Nme ""13 SQLCHAR 0 255 "\"|\"" 13 InvCurrFSCRptCat2Nme ""14 SQLCHAR 0 255 "\"|\"" 14 DX1 ""15 SQLCHAR 0 255 "\"|\"" 15 DX2 ""16 SQLCHAR 0 255 "\"|\"" 16 DX3 ""17 SQLCHAR 0 255 "\"|\"" 17 DX4 ""18 SQLCHAR 0 255 "\"|\"" 18 InvGroupNme ""19 SQLCHAR 0 255 "\"|\"" 19 InvDivNme ""20 SQLCHAR 0 255 "\"|\"" 20 InvBilArea ""21 SQLCHAR 0 255 "\"|\"" 21 InvHospNme ""22 SQLCHAR 0 255 "\"|\"" 22 InvLocNme ""23 SQLCHAR 0 255 "\"|" 23 InvProvNme ""24 SQLCHAR 0 255 "|" 24 InvRefProv ""25 SQLCHAR 0 255 "|\"" 25 InvTotChgAmt ""26 SQLCHAR 0 255 "\"|\"" 26 InvBal ""27 SQLCHAR 0 255 "\"|\"" 27 TxnPayCdeNum ""28 SQLCHAR 0 255 "\"|\"" 28 TxnPayCdeNme ""29 SQLCHAR 0 255 "\"|" 29 TxnPayCdeCatNum ""30 SQLCHAR 0 255 "|" 30 TxnPayCdeCat ""31 SQLCHAR 0 255 "|" 31 TxnAdjAmt ""32 SQLCHAR 0 255 "|" 32 TxnPayAmt ""33 SQLCHAR 0 255 "|\"" 33 TxnCreditAmt ""34 SQLCHAR 0 255 "\"|\"" 34 TxnDebitAmt ""35 SQLCHAR 0 255 "\"|\"" 35 TxnPostDt ""36 SQLCHAR 0 255 "\"|" 36 PayPostPdIDX ""37 SQLCHAR 0 255 "|\"" 37 PayFCSNme_Pmt ""38 SQLCHAR 0 255 "\"|\"" 38 TxnNum ""39 SQLCHAR 0 255 "\"|\"" 39 TxnCPTCode ""40 SQLCHAR 0 255 "\"|\"" 40 TxnCPTDesc ""41 SQLCHAR 0 255 "\"|\"" 41 TxnModAll ""42 SQLCHAR 0 255 "\"|\"" 42 TxnPostPdIDX ""43 SQLCHAR 0 255 "\"|" 43 TxnServDt ""44 SQLCHAR 0 255 "|" 44 TxnthruServDt ""45 SQLCHAR 0 255 "|" 45 TxnChrgAmt ""46 SQLCHAR 0 255 "|" 46 TxnUnits ""47 SQLCHAR 0 255 "|\"" 47 TxnUnitsBase ""48 SQLCHAR 0 255 "\"" 48 TxnUnitsDur ""49 SQLCHAR 0 255 "\"\r\n" 49 TxnUnitsTme ""This imports everything, but has the " text qualifiers which is why I used the format file to begin with...any suggesions?Bulk insert Tbl_Txn_AEHN_Temp FROM'D:\Data\AEHN\lnepayTest.txt'WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = '|', ROWTERMINATOR = '\n', KEEPNULLS)GOCheers |
|
|
|
|
|
Bulk import filtering import???