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 |
|
Sarinjoshi
Starting Member
3 Posts |
 Posted - 2012-04-23 : 10:26:54
|
| information about the failure.,-1073450974,2555 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-23 : 11:20:36
|
| do you've any other error messages thrown before this error by the package? Also is it only happening when you execute it from job or is it happening even when you run package in BIDS?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-23 : 11:29:38
|
| the error message is obvious. The used credentials dont have insert permissions to the table specified in the oledb destination ( ie 'tbl_Actual_Deposit_OCC_new'). Ask your dba to give you access or use a credential which have access to this table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-23 : 18:57:20
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-04-24 : 05:17:57
|
| It seems OP had deleted all his/her repliesMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
s