Posted by Erland Sommarskog on 03/25/06 00:12

mike (mike.a.rea@gmail.com) writes:
> Good question, something I will have to look into. It is taking data
> from some access tables and pulls them into SQL However these access
> tables are on a different machine, not on the SQL server. Maybe the
> failure is on the machine that has the access tables.
> By the way it runs just fine if I run it from the SQL server. We just
> want to be able to run it from an individual workstation.

The error message comes from the SQL Server OLE DB Provider, so the
problem is not likely to be with the access to the Access databases.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: French characters are not imported properly with bcp
• Prev in forum: Re: Help selecting an alias
• Thread view: Re: Using OSQL and DTSRUN

[Reply to this message]