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 |
|
cheaptrick_la
Starting Member
3 Posts |
 Posted - 2010-09-14 : 09:50:36
|
| Hi at all,I have a SSIS-package including a (VB)-Script-task. If I run it in Visual Studio or in Integration Services as stored package it works fine. If I try to run it as a job in SQL Server Agent te package doesn't run. It seems there is a problem with the script-task. For testing issues I put 2 mail task around the script task an I recieve only mails from first mail task.Any ideas how to resolve this problem?Regards |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-14 : 11:50:18
|
| what error are you getting? what does the script task do? |
 |
|
|
cheaptrick_la
Starting Member
3 Posts |
Posted - 2010-09-15 : 01:07:01
|
| I'm getting no error and it seems the package is working fine till it reaches the script task. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-15 : 08:48:57
|
| what does it do. seems the sql agent service account doesn't have permissions to do whatever it is you're trying to accomplish. may be the script task, maybe not |
|
|
|
cheaptrick_la
Starting Member
3 Posts |
Posted - 2010-09-20 : 03:06:33
|
| I'm running this job under a proxy, the same proxy other jobs working fine with.This is also the user I'm testing my packages with.So my idea is there may be ist a problem with execution rights for script tasks.Again, I'm gettin NO error the job just seems to hang!The script task is searching for text files (name = #date##Fixfilename#.txt in a given (via variable) directory.Then it checks in a database-table if the file is already worked. The result comes back via another variable. |
|
|
|
|
|
|
SSIS-Package with (VB) Script Task doesn't run as