• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

SQL Job just spins when trying to execute SSIS package that executes a process

Hi,

I have an SSIS package that runs fine from the Visual Studio development environment.  However when I upload it to the package store and try to run it from a job the job just runs and runs and runs and runs (I've lost patience at about 20 mins) and never does anything.  I know it doesn't do anything because the first step is to run a batch file that downloads some files from an FTP server.  Those files never show up.  I've tried running the package in VS as the account that the SQL server Agent uses and it runs fine.  I've tried running the batch file while logged into the box that the SQL server agent uses and no problems there either.  So permissions don't seem to be the issue.  Since it never errors out I can't tell why it never does anything and if I put a short timeout it could only tell me it timed out.

Any help here would be great.  I can't seem to figure out what's going on here.
0
afacts
Asked:
afacts
  • 2
2 Solutions
 
Surendra NathCommented:
is the package have any parameters, then please check if the same parameters are being passed from VS  and the Job.

Enable logging on the SSIS package and check the error log, if you see some error....

Put some echo statements re-routed to a text file in the batch file and check, if the batch file is actually called (kicked) and if the batch file is called, then see at what statement it hangs up...

it actually helps to narrow down the issue.
0
 
afactsAuthor Commented:
Thanks, actually the problem was that it needed to run with a user with the appriopriate permissions, but thank you for the effort.
0
 
afactsAuthor Commented:
Because I found the solution myself.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now