Solved

Problem with SQL Job

Posted on 2013-01-16
1
229 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 39

Accepted Solution

by:
lcohan earned 500 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

770 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