Solved

Problem with SQL Job

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL STANDARD CORE 7 31
Re-appearing SQL Server Agent jobs 7 29
SQL SERVER - Index skipped a number 2 26
MS SQL AND PASSING A TABLE NAME TO A SPROC 5 14
In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

856 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