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 |
|
kwilliams
194 Posts |
 Posted - 2003-03-26 : 15:54:25
|
| I really hope that someone can help...I created a table w/SQL Server 7 that gets updated from an Excel doc using a DTS package. Then I created a front-end using ASP that has a refresh set up that refreshes the page every 1 minute.Basically, the DTS page I created has 2 steps: 1) Delete data from "dbo.Election2003"; 2) Copy data from Excel doc into "dbo.Election2003"Whenever I manually execute this package, it works great. But when I schedule the package to run every 1 minute for testing, it only does the 1st step of deleting the table's contents, and doesn't do the 2nd step of copying the data from Excel into the SQL table.I'm not sure at all what's going wrong, or how to fix it. I have a deadline that's very quickly approaching, so any help would be greatly appreciated. Thanks.KWilliamskwilliams@douglas-county.com |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-03-26 : 16:03:54
|
| I'm guessing here, but the problem could be any of1 - The source excel file isn't found when scheduled (I'm guessing your development and commercial server are different)2 - The permission you created the job under do not include physical references to the source file. What is the role of the user scheduling the job anyway?HTHSam |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-26 : 16:14:21
|
| Does the job report an error (check the job history, make sure that you check the box to show details)?Tara |
|
|
|
kwilliams
194 Posts |
Posted - 2003-03-27 : 10:47:09
|
| Hi SamC & tduggan,Thanks for your quick responses. First, the development & commercial server are the same server. Second, I don't see where you set permissions for the source file in the DTS package. Can you point me in the right direction so that I can check this option out? Third, the job does report an error...it says that Step 1 runs fine, but Step 2 fails. Step 1 is the deleting in SQL, and Step 2 is the import from Excel into SQL. I looked at the properties for the Excel import in the DTS package, and it has "Admin" as the User Name, and no password. I automatically sets this up, and if I try to change it or take "Admin" out, the entire DTS package gets an error message.I believe that the issue is with the import from Excel into SQL, and it could be related to SamC's #2 option, but I'm not sure what to do or how to fix it. I need to get this up and running very soon, and before Election Day next Tuesday. Any more help would be greatly appreciated. Thanks.KWilliamskwilliams@douglas-county.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-27 : 12:37:14
|
quote:
I don't see where you set permissions for the source file in the DTS package. Can you point me in the right direction so that I can check this option out?
Double click on the job and check who the owner is. The owner must have the necessary privileges to perform the entire job. If it is a Windows account, then check the privileges on that account. If it is a sql account, then you might want to change it to a Windows account.quote:
Third, the job does report an error...it says that Step 1 runs fine, but Step 2 fails. Step 1 is the deleting in SQL, and Step 2 is the import from Excel into SQL.
What is the error for step 2? You have to show the details to get the error message. There is an option in the job history to show details, click that option. Then tell us what the error is. We have to know what the error is in order to help you out.Tara |
|
|
|
kwilliams
194 Posts |
Posted - 2003-03-27 : 13:01:26
|
| Hello Tara,I just solved the problem. The error was due to me browsing for the file, and not mapping where the file is correctly. I was using the drive, and I needed to put the entire path in. My stupid mistake, but I guess that's how us newbie's learn. Thanks for all of your help. I REALLY appreciate it. Every time I've had a problem with SQL, I've asked this forum for help. And every time, I get a quick response. How great...but hopefully I won't have to contact you too much more, as I learn:) Thanks again.KWilliamskwilliams@douglas-county.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-27 : 13:10:39
|
| Well even we need help sometimes. There are plenty of times where we start a thread asking for help.Tara |
|
|
|
|
|
|
|
|
NEWBIE: Scheduling Problem w/DTS Package