| Author |
Topic |
|
trusted4u
Posting Yak Master
109 Posts |
 Posted - 2002-11-11 : 01:22:03
|
| Hi: I have created a DTS package which imports foxpro table in my db. It works fine when run manually. I want this package to run daily at 10.00am. so I tried scheduling it but it didn't work out. Then I tried creating a job which uses DTSRun utility and scheduled it, the job executes but the package doesn't gets executed. I am directly working on the Server using SA login and pwd. The cmd line in the Job is : Master.DBO.XP_cmdshell 'DTSRun /S MYSERVER /U SA /P SA /N DTSPACKAGE1'. Any help will REALLY be appreciated. ITS VERY URGENT. Thanks, Marjo. |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-11-11 : 02:17:12
|
| Do you get any error message? |
 |
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2002-11-11 : 02:28:07
|
| No. I have created a notification for myself which should run after the job completes the execution. I get the notification properly, saying "Job executed Successfully". But the tasks for inserting the records which i have given in the DTS package doesn't get executed. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-11 : 05:08:58
|
| Do you have any error checking in the pakcage?Maybe it's failing but you're not reporting the error.Suspect it's due to the user under which the job is executing. When you rune the exec command from query analyser does it work?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.Edited by - nr on 11/11/2002 05:11:00 |
|
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2002-11-11 : 05:25:25
|
| I am not checking for any errors. And regarding executing package manually, I am doing it from the Enterprise Manager itself and not Query Analyzer.Thanks. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-11 : 05:51:15
|
| What happens if you execute from query analyser.It sounds like a permissions problem.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2002-11-11 : 07:42:21
|
| I don't think there is any permission problem. Bcoz the owner of the package and job is same. I tried to Execute the package from Query Analyzer and got the following output :output ------------------------------------------------------------------------------------------------------------------- DTSRun: Loading...DTSRun: Executing...DTSRun OnStart: Drop table Results3 StepDTSRun OnFinish: Drop table Results3 StepDTSRun OnStart: Create Table Results3 StepDTSRun OnFinish: Create Table Results3 StepDTSRun OnStart: Copy Data from Results to Results3 StepDTSRun OnError: Copy Data from Results to Results3 Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100Error Detail Records:Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100Error: -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: 0DTSRun OnFinish: Copy Data from Results to Results3 StepDTSRun: Package execution complete.(32 row(s) affected)Thanks,Marjo. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-11 : 12:21:22
|
| Are you executing the package manually from your machine? If so, you probably have a service pack problem. You will need to install the same service on your machine that the server is running and then recreate the package. DTS has problems when the client machine and the server machine are using different service packs. |
|
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2002-11-12 : 04:26:22
|
I am trying to create as well as execute the Package on the Server. I am not working on the client. And if I try to execute the package manually through enterprise manager, it works perfectly but when I create a scheduled job to do the same, it fails. I am not able to execute it through Query Analyzer also. As U can C from the error msg, it states some Driver Problem. 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 .Today is the 3rd Day, and still stuck with this problem.Can Anybody Plzzzz HELP ME.Thanks.Marjo. |
|
|
|
|
Package for imp dbf not getting exec in Job??