February 8, 2012 at 10:52 am
This SSIS Package runs fine(truncates and fills in the tables) and does what needs to be done when executed by itself:
Truncate the tables
Fill the tables from a text file
When executed from SQL server Agent jobs, it looks as though it is completed successfully(It does not have any error messages)...but it did not do anything. It did not truncate or load the tables
This what is in Job history:
Started: 11:42:48 AM Finished: 11:42:49 AM Elapsed: 0.797 seconds. The package executed successfully. The step succeeded.
I am running it as proxy. Also I have "On Failure action", "Quit the job reporting failure"
Please let me know what I am doing wrong. Thank you,
Geetha.
February 8, 2012 at 11:37 am
Have you configured logging inside the SSIS package? It gives more detailed information about each of the control flow tasks inside the SSIS package.
You can read a blog post that I wrote to configure logging in an SSIS Package.... http://learnsqlwithbru.com/2009/11/26/configure-logging-in-ssis-packages/[/url]
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2012 at 1:56 pm
Thank you so much Bru!!! That blog was very helpful...this is the first time I am scheduling to execute the SSIS package. It was only doing the validation. It was not doing the execution and I fixed it. Thanks again.
Geetha.
February 8, 2012 at 1:58 pm
Good to know, glad to help..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply