Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2002-04-08 : 03:58:03
|
| Sir,I am trying to import data from MAS 90(ERP Package) to sQL 2000 using MAS 90 32-Bit ODBC Driver at Source end for DTS. when the Package is set up,the data is transferred for the first time without any error. But later on when it is executed as a job it gives out,the following eerror:... Loading... DTSRun: Executing... DTSRun OnStart: Drop table Results Step DTSRun OnFinish: Drop table Results Step DTSRun OnStart: Create Table Results Step DTSRun OnFinish: Create Table Results Step DTSRun OnStart: Copy Data from Results to Results Step DTSRun OnError: Copy Data from Results to Results Step, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from Results to Results Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.Thanx in advancePurushotham |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-04-08 : 08:50:43
|
| Sounds like the credentials the SQL Server Agent is running under does not give it access to the DSN you set up.setBasedIsTheTruepath<O> |
 |
|
|
purisqlserver
Yak Posting Veteran
73 Posts |
Posted - 2002-04-09 : 00:31:05
|
| I did setup the system DSN,its working fine now.Previously, I had set up the user DSN with sql server agent running with local system account.Thanx |
|
|
|
|
|
|
MAS-SQL Import