We are having problems with scheduling a DTS package job only when it
uses a system DSN for an ODBC connection and this only seems to happen
when we reboot the SQL Server. (Any non-ODBC type packages schedule run
just fine.) We log into the SQL Server as administrator and schedule the
DTS package. The SQL Server Agent uses the same domain administrative
login. The ODBC driver is pointing to a different server for data. The
job seems to crash when it hits the ODBC data pump:
DTSStep_DTSExecuteSQLTask_7 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_8 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_8 DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259
(80004005) Error string: [ProvideX][ODBC Driver][FILEIO]Table is
not access... Process Exit Code 8. The step failed.
Any ideas? Help apprecaited. Thanks.
Frank



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Looks like you are using the ProvideX ODBC driver. Does this meet the
minimum conformance levels for MSDASQL? If not then the provider cannot be
gauranteed to work with DTS.

249043 INFO: Requirements for Developing ODBC Drivers for Use with MSDASQL
http://support.microsoft.com/?id=249043

Regards,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.