My DTS package runs normally, but hangs when run as a SQL Job

5 pts.
Tags:
ActiveX
DTS Local Package
DTS package
Job scheduling
Microsoft Access
SQL
SQL Jobs
SQL Server 2003
Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows: '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ I Function ConvertIssue3() Dim objDB Set objDB = CreateObject("Access.Application") objDB.OpenCurrentDatabase("H:depConvertConvert.mdb") objDB.Run "ConvertIssueSlips" objDB.CloseCurrentDatabase objDB.Quit ConvertIssue3 = DTSTaskExecResult_Success End Function Originally I thought it might be a security issue, but when I change ownership of the job to a user without admin privileges, the job simply fails, where if I make sure the owner is an admin, the job hangs. In the package I changed clicked both boxes in the work flow properties tab: Use ActiveX script and Execute on main package thread. I've tried just about every combination of these options, and I still have the hang problem. Does anyone have any idea what might be going wrong. I've searched the internet for a while and have yet to come up with a solution. If not, does anyone know of a different way to run the Ms Access file? Any advice will help. Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Is the H drive a drive local to the SQL Server or is it a mapped drive?
    66,085 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following