Solved

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

Posted on 2013-06-24
3
374 Views
Last Modified: 2016-02-11
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
Comment
Question by:afacts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 500 total points
ID: 39273470
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
 

Accepted Solution

by:
afacts earned 0 total points
ID: 39311695
Thanks, actually the problem was that it needed to run with a user with the appriopriate permissions, but thank you for the effort.
0
 

Author Closing Comment

by:afacts
ID: 39324409
Because I found the solution myself.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Using this function 4 53
VLAN 1 Line Protocol Down 9 85
Linked Server - SP with Param to VIew 7 29
sql server major issue  need help 2 81
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question