The SSIS 2008 R2 job does not complete execution

25 pts.
Tags:
SQL Server 2008
SQL Server 2008 R2
SQL Server Integration Services
SQL Server tables
SSIS
SSIS 2008
SSIS Job
I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database.

What the package does.

1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly.

2. Truncate the tablse. Verified to see the record count is 0.

3.Copies the data from the FTP'ed file to the tables. Verified to see the table is loaded.

4.Calls a stored procedure. Verified the log table to see the message of the last step in stored procedure is executed.

5.Added one more last step in the package to log an entry in the table to see the lat step in package is executed. This also works fine.

6. The job still shows "In Progress..." I have to manually close this job.

Any help

Answer Wiki

Thanks. We'll let you know when a new response is added.

What happens if you log into the server and run the package manually from the command line?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Iamhere980
    It was the same result, the job was still hanging. Atlast i found the issue. I disabled all the steps in the package and enabled one step at a time and tried to run the job. I figured the step that was causing the issue, the issue was, afterdownloading the files, it used an executable named ND.EXE to archive the files. This step was hanging since the ND.EXE was not exeuting in a 64 bit environment.
    25 pointsBadges:
    report
  • Iamhere980
    Thanks a lot MrDenny for replying to this issue.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following