Accessing a DSN through a Sql job

I am trying to execute an SSIS package (which accesses a dbf file through an odbc connection) through a Sql job, but the package log reports an error of "Disk or netowrk error". When I execute the package in the IDE, the package executes fine. When I run the manifest on the DB server, I can execute the package with no errors. But, when I create the job, and try to execute the job, it fails. I thought at first that the user didn't have privileges to the directory that the file existed in, but that isn't the case.

Can anyone shed some light on how to accomplish what I am trying to accomplish? It seems like this would be a common use of SSIS, but I cannot seem to get it to work.

Thanks in advance for any assistance you can provide!

Craig

This seems to be security issue, as your package can execute fine within the IDE, but not through the SQL Agent. I'd check the SQL Agent user account, along with the proxy details on the job.

|||

Thank you for your reply, Deniz.

Do you know of any web sites that I can get more information on setting up the Sql Agent account permissions? I granted that user admin privileges, but still receive the same error.

Craig Browder

craigster1976@.msn.com

Accessing a .dbf file in SQL Server 2000

I am new to SQL Server 2000, and anxious to get started. I'm beginning with a project that will use a file saved in the .dbf(dBase) format.

I looked in the Books on Line under 'OLEDB Provider' and didn't find any help about dbf files. I did use the 'OLEDB Provider for Jet' example to create a linked server that accessed an Excel spreadsheet.

Can someone give me some pointers in accessing my dbf file in SQL Server 2000?

Thanks for any help.

Randyyou can create an odbc datasource and then set up a linked server with the 'ole db for odbc' driver. See in books online for more info.