May 27, 2009 at 7:34 pm
Hi,
My SSIS job does not stop when scheduled as a job but when it is run from the BI Visual studio it takes <5 minutes to run.
I have changed the protection level of the package to DontSaveSensitive as the sensitive information is stored in config files.
I open the package in VS using my windows authentication and the package is running as SQL Agent Service Account.
I do not know what i am missing
May 27, 2009 at 10:15 pm
You have made a statement without asking any questions!
Please describe what the package does and at what stage it hangs.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 27, 2009 at 11:58 pm
I am not sure at what point it hangs but I guess it is probably at the stage of unzipiing the files, I am doing some tests to rule out this issue
May 28, 2009 at 12:21 am
Does the SQL Agent user have permissions to access the files?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 28, 2009 at 12:28 am
Othere SSIS packages running under the sql seerver agent user access the same folder, So I am not sure if that was causing this issue, as i do not have an error when the package runs I am ruling out this. After googling I found that there are issues when SQL server agent runs a winzip task. I will test the code by disabling the winzip task and see how it works
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply