DTS - Comma delimited, Double Quotes Text Qualifier Text file -
05-03-2004
, 04:26 PM
Hi
I am a newbie to DTS programming and facing problem in bulk inserting data from a text file to Sql Server 2000 table. Created table in Sql Server 2000 prior to bulkinsert. The text file is Comma delimited and Double Quotes Text Qualifier. When bulk inserting using DTS object model programming, gives error as "The Statement is Terminated ". There is no property for "Text Qualifier". Can anyone help me how to solve this
Thanks a ton
pk |