Can't run SSIS package from sqlagent jobs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Can't run SSIS package from sqlagent jobs

Can't run SSIS package from sqlagent jobs

Rate Topic

Display Mode

Topic Options

Author

Message

Krasavita

Posted Tuesday, October 02, 2012 2:02 PM

Ten Centuries

Group: General Forum Members
Last Login: Friday, April 19, 2013 8:15 AM
Points: 1,251, Visits: 1,840

Hello,When I run package from integration it works,but I am trying to run SSIS package from sqlagent jobs and get this error:

Post #1367276

benjamin.reyes

Posted Tuesday, October 02, 2012 4:31 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:34 PM
Points: 198, Visits: 745

http://support.microsoft.com/kb/918760

Post #1367328

sathiyan00

Posted Wednesday, October 03, 2012 12:38 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 60, Visits: 325

use protection level as encryptallwithpassword and give password...it works for me...but i tried without any package configuration...hope this will work...

Post #1367414

balasach82

Posted Wednesday, October 03, 2012 1:20 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

Save the package with password. Use EncryptAllwithPassword in package properties.

Post #1367430

ard5karthick

Posted Wednesday, October 03, 2012 2:54 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 5:51 AM
Points: 38, Visits: 129

Hi Krasavita,

IN the properties change the Protection Level from "Encrypt Sensitive with User Key" to "Encrypt Sensitivity with Password" and enter a password in package password.

Now you can run this package using SQL agent.

You will be asked for the password while creating the job.

Post #1367473

Krasavita

Posted Wednesday, October 03, 2012 7:48 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, April 19, 2013 8:15 AM
Points: 1,251, Visits: 1,840

Hello,

This is still not working

Post #1367684

Krasavita

Posted Wednesday, October 03, 2012 7:51 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, April 19, 2013 8:15 AM
Points: 1,251, Visits: 1,840

Error:

Post #1367686

T_Peters

Posted Thursday, October 04, 2012 10:35 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 10:58 AM
Points: 727, Visits: 1,086

I ran into this same issue earlier this week and found this article very helpful in solving my problem, http://www.proteanit.com/b/2008/02/13/ssis-ftp-task-code-to-set-the-password/
It is using a Script task to set the FTP password

Tim

Post #1368570

Ignacio A. Salom Rangel

Posted Thursday, October 04, 2012 1:57 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:49 PM
Points: 3,051, Visits: 1,356

Krasavita (10/3/2012)

Error:

Krasavita, it will be nice if you let the error in the post, so others could use the post to solve a similar error. Were you able to solve your problem? If you did could you please share the solution? Thanks in advance.

My blog

Post #1368683

« Prev Topic | Next Topic »

Permissions