Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBScript in a scheduled DTS job doesn't work

Status
Not open for further replies.

redlam

MIS
Jun 28, 2000
218
US
Hi.
One of my programmers has created a DTS package using VBScript. The package can be executed manually but when we schedule it in a job, it doesn't run properly. When the job is executed manually or scheduled, the status indicates that it is running but it never stops! When the DTS package is executed outside the job - it takes only a minute or two. Anyone have any ideas?
 
You need to make sure that everything that the package is doing has permissions to do so under the security context of the SQLServerAgent's account.
Tom Davis
tdavis@sark.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top