June 20, 2012 at 7:53 am
Hi All,
There is only one Data flow task in my package.SSIS package has been configured package source as SQL Server.It is in other server.
This package has been configured as SQL Agent job and runs daily successfully.
But there is no data in destination table.
Source and Destination both are SQL Server.
Please give me solution.
June 20, 2012 at 9:14 am
Hi,
Check your package for what its supposed to do on error? There are properties called "fail parent" and "fail package" on most tools.
If its set to not fail package, or parent on a task - then it wont error.
Dan
June 20, 2012 at 10:55 am
Is it actually set up to fail in some way if it doesn't find any new data? A lot of case could simply be something that filters out all of the incoming data. Unless you specifically check to see that there is data to import, the job can run and end up importing 0 records.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
June 26, 2012 at 3:56 am
Hi
Thanks for your reply.
FailParent and Failpackage both are set to False.
There is one stored procedure in second step.it is running and updating records successfully.
The only problem with the package.
I couldn't identify the issue.
June 26, 2012 at 5:30 am
Hi,
Finally I found the solution.
Its the problem with job configuration.They have configured the job to run at step 2(start step).
Thats why it didn't run the Step1.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply