csv DTS not working

[mlabac]

I have a csv file that I need to import into SQL Server. I download the csv automatically. I am trying to create a DTS package to import in to SQL Server. DTS can not delimit the fields unless I open the csv file in excel and save as a csv, then the dts package can delimit the fields and all is good.

I can not open the file and save as this has to be automated. I have been looking for a way to open the file via Visual Basic and save as, but have not had any luck.

Has anyone run across this type of problem?

Thanks

 

[jhall01]

Is the CSV format ms-dos or Mac? That could be part of the problem.

Does renaming the csv to txt using FSO fix the problem?

 

[gradley]

When you say DTS cannot delimit the csv file unless saved in Excel, are you trying to import as an Excel spreadsheet or as a text file?

If the file has delimiters (commas, tabs, etc..) a text file import should recognize this.