?
Solved

Problem with SQL Job

Posted on 2013-01-16
1
Medium Priority
?
241 Views
Last Modified: 2016-02-11
Our company changed a Vendor and I changed SSIS package in one step where a Data Flat File FTPed from different location. I tested the package and it works fine. I did not change neither Name of the Package or its location and did not touched a Job that is running this Package on Hourly bases. I ran the job successfully. But it did not awake the Package. But History Log shows that the Job and the Package ran successfully. I never came to this problem before. Probably somebody did and can advise me what should I do. Thank you.
0
Comment
Question by:Burzhuin
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 1500 total points
ID: 38784419
How do you run it via the job from SSIS store or as a DTSX physical file?
If you have it saved in Integration Server rather than file then I suggest update the job as well - just open that step, click the [...] navigate and select the updated package and try it again.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

831 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