Solved

Problem with SQL Job

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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…

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now