ODBC Error in scheduled DTS job

From: dxm1 (anonymous_at_discussions.microsoft.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 11:11:04 -0700

We are currnetly evaluating SQL Server, and have encountered the following problem:

1) We are trying to schedule the import of a .csv file
2) We set up the job in the DTS Import/Export wizard
3) We select ' Microsoft Text-Treiber (*.txt;*.csv)' as the Data source Name
4) We then schedule the job.

When run immediately, the import is successful. The scheduled job, however, fails.
The error message returned is:

Executed as user: XXXX\****. ...tart: Copy Data from CallDetailRecordDiagnostic.csv to [CDR].[dbo].[CallDetailRecordDiagnostic] Step DTSRun OnError: Copy Data from CallDetailRecordDiagnostic.csv to [CDR].[dbo].[CallDetailRecordDiagnostic] Step, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 1023 (3FF) Error string: [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help co... Process Exit Code 1. The step failed.

Any idea what the problem may be, or perhaps a suggestion of an easier (or more reliable) way to accopmlish this task?

thanks.

Relevant Pages

  • Re: CSV Scheduled Report
    ... I created the query inside of a Stored ... > save the results to a .CSV file. ... How can I schedule this job so ... > how can i make sure that the format of the CSV file is correct. ...
    (microsoft.public.sqlserver.server)
  • CSV Scheduled Report
    ... I created the query inside of a Stored ... save the results to a .CSV file. ... file there's always the time date and step of the job and also the CSV format ... How can I schedule this job so ...
    (microsoft.public.sqlserver.server)
  • MAcro Needed
    ... How do you write a macro that takes a 7 day schedule with Employee ID ... and create a csv file that shows: ...
    (microsoft.public.excel.misc)
  • Importing data from a csv file
    ... I am trying import data from a csv file but csv file is not in the list of ... .pst, .sc2, and Schedule+ 7.0. ... Why is comma separated values missing from ...
    (microsoft.public.outlook.calendaring)