Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba111
Starting Member
22 Posts |
 Posted - 2010-11-05 : 22:12:49
|
| HI,I create very simple package in SSIS,DATAFLOW-->EXCEL SOUCE-->DATA CONVERSION TRANSFORMATION-->OLE DB TARGET, Works fine. I want to schedule this package every day. I am scheduling this package "SQL SERVER AGENT" I follow all steps mention right herehttp://www.sql-server-performance.com/articles/biz/Scheduling_a_SSIS_Package_in_SQL_Server_Agent_p3.aspxstill getting error "PACKAGE FAIL "CHECK HISTORY LOG" i m thinking VALIDATION OR PERMISSION issue. Please help me how i can fix this issue,Thanks for help. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-11-06 : 10:07:18
|
right click the job in object explorer and see the history log.Maybe there you can read why the job is failing...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
SSIS SCHEDULE ISSUE