| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2008-03-31 : 11:25:44
|
| Hello all,I have designed a SSIS Package. The process of SSIS package is import the data from Excel sheet daily. The package is working fine. When I run from SQL agent job, it is continuously failing. I have created credentials, proxy and I have mapped it. I am doing this process by remote desktop connection. I red lot of articles, nothing was helped me. I hope I will get a solution over here!!ThanksKrishna |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 11:28:34
|
| What error you are getting in SQL server log? Do you have permission to run jobs? |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 11:29:13
|
| Yes I have SA rights with me. The Account is Domain account with windows authentication. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 11:31:22
|
| Then post the error. We need some info before we can give answers? |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 11:33:44
|
| This is The Error I got.Date 3/31/2008 10:32:43 AMLog Job History (ACTIVE MANAGERS)Step ID 0Server CBIESQLJob Name ACTIVE MANAGERSStep Name (Job outcome)Duration 00:00:02Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageThe job failed. The Job was invoked by User CHRISBANKS\kkumar. The last step to run was step 1 (STEP A). |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 11:36:54
|
| This is not the error looking for :Go to Job history: and click jobs and you will see clearly what is wrong or check application(if you have set to write in app log if job fails) |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 11:43:21
|
| Sodeep, I got this message from job histry only. If you want let me post the print screen. |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 11:47:04
|
| Here is the image with error message!![URL=http://img521.imageshack.us/my.php?image=14204597tc4.jpg][/URL] |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 11:55:50
|
| Initially i red that article. But that havn't help me!!! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 12:01:19
|
| Since you already have Sysadmin, why are you dealing with credentials/Proxy? |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 12:04:48
|
| I tried with Both.I got the same error in both methods |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 12:11:03
|
| Is there any problem with Remote access..? I have added my domain account in Com Security Edit limits also!! |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-31 : 13:36:45
|
| CSK,There's one thing that I didn't see on this thread and it's something a lot of people with DTS background are leaving behind which is the "Protection Level". When you saved the SSIS package to your server to be executed by the SQL Agent, what package protection level did you set that to?I have a feeling that you have it set to "Encrypt sensitive data with user key", which would cause your package to fail when it gets executed by an user other the account you're using to execute the package locally.Wanna do some reading on SSIS Package Protection Level?http://technet.microsoft.com/en-us/library/ms141747.aspx |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 13:50:00
|
| igorblackbelt, Thanks for the suggesion.The first step i have changed the Pacakge propertis Security level from EncryptSensitiveWithUserKey to ServerStorage. But still i am getting the error :(-- Krishna |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-31 : 13:57:00
|
| Just for this exercise, try saving with a password and see if that helps. You'll have to type the password on the agent again. |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 13:58:08
|
| Okay!! Let me try this exercise!!Thanks-- Krishna |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 14:06:56
|
| Igor, Now i got the following error.The package could not be loaded. The step failed.-- Krishna |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-31 : 14:09:28
|
| Now it could be something inside of the package, is the location a UNC path? Is it accessible from the server you're running it from? Does the account that's accessing the excel spreadsheet has access to the share you're accessing? |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-03-31 : 14:14:35
|
| I am accessing the package in same server. The domain account having full rights to access the excell sheet(even .xls in the same path of the package).Out side of SQl Agent the package is running fine. This is the command line i am getting/FILE "D:\Active Mangaers\Storemangers_update_test\Storemangers_update\Package.dtsx" /DECRYPT 123456789 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 14:17:25
|
| Your problem is with Security issues:Did you check the articles i have provided? |
|
|
|
Next Page
|
SSIS-SQL AGENT Problem