I used the Enterprise Manager's Import wizard to import data from a CSV file
with column headers in 1st row. Row delimiter is LF.

I set the Save as Visual Basic options and then execute the import. The file
gets imported OK. Then I delete the table and use the VB module in a project
to do the import on the exact same CSV file. But I get "MS DTS Flat File
Rowset Provider incomplete file format information - file cannot be opened."
error msg on the Execute call.

Any ideas how to tweak the generated VB code to get around this?

LMcPhee

Never mind - found the answer. The generated code does NOT specify the
Connection's ConnectionProperties("Row Delimiter") value. I added a line to
set to = vbLf and it worked.

"lmcphee" wrote: