Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changed SSIS now won't run in a job Expand / Collapse
Author
Message
Posted Wednesday, May 1, 2013 3:58 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 20, 2013 11:45 AM
Points: 63, Visits: 255
I had a SSIS package running fine for months through a SQL Agent job. Then ... I deleted a task and re-saved to MSDB now the job just hangs and never finishes. I can run the actual package and all runs fine, I can execute the package in SSMS - using the Integration Services connection and it runs fine. I did not change anything in the job itself. Can someone give me some suggestions on how to trouble shoot this? I'm pretty much a beginner and any help would be appreciated!! TIA!
Post #1448639
Posted Wednesday, May 1, 2013 11:07 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:16 AM
Points: 1,151, Visits: 1,588
Are there any saved / protected login credentials in the package? The protectionLevel might be set to EncryptSensitiveWithUserKey, which is why it works for you and not the SQL Agent account.
Add some logging to the package and check where it's hanging. Or run a SQL trace and check what's happening during the agent execution.
Post #1448686
Posted Thursday, May 2, 2013 10:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 20, 2013 11:45 AM
Points: 63, Visits: 255
Ahh … password!
I initially had a password on the package, however when I made changes to the package I changed the security setting to ServerStorage and saved it to MSDB. The job then stopped working. After your posting I have now gone back and resaved the package with EncryptAllWithPassword and entered the old password but it still will not run through a job (runs fine in bids).
Post #1448889
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse