こんなデータでエラー
"*"," ","080831","100003","20","414","20",25830," ","1"," ","3","01","212","1137",25830," "," ","00","3"," 適用",200808,"damy data "
ダブルコーテーションはいらない
sqlserver2000 dts テキスト書き出してダブルコーテーションをつけないようにするには
*, ,080831,100003,20,414,20,25830, ,1, ,3,01,212,1137,25830, , ,00,3, 適用
適用の後の余分なフィールドを削除して汎用受入できた
0 件のコメント:
コメントを投稿