Solved

Problem with SQL Job

Posted on 2013-01-16
1
232 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
[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
1 Comment
 
LVL 40

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

730 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