x

SSIS package is failing

Hi I have a SSIS package created by a developer who left the company now. It used to run with his domain active but now it is not running. As a DBA I tried to run the job but now it is not executing.

What might be the reason and how to resolve this...This is very urgent

Thanks Munna
more ▼

asked Aug 30, 2010 at 09:15 PM in Default

munna gravatar image

munna
51 5 5 6

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Take a look on the Job History for error returned by the SSIS package... From the error message you can see what is wrong. Or if you do not understand the error message, then post it here a we can probably help you.
more ▼

answered Aug 30, 2010 at 11:37 PM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(comments are locked)
10|1200 characters needed characters left

I'm no SSIS expert but chances are he created the package using the default SSIS protection level setting "encrypt sensitive with user key". This setting ties the package directly to the user account so if his account is no longer active then the package won't work.

To fix this I suggest converting the package to "don't save sensitive" and then implementing a package configuration. However, if that is out of your comfort zone I think you could also convert the protection level to "encrypt sensitive with password" and then specify a custom password instead. This option requires the password to be supplied when the package is executed so it's tricky (to say the least) to automate packages but it should at least allow you to run it manually.
more ▼

answered Sep 02, 2010 at 09:24 AM

Lawndemon gravatar image

Lawndemon
105 3 3 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x927
x27

asked: Aug 30, 2010 at 09:15 PM

Seen: 1085 times

Last Updated: Aug 31, 2010 at 03:41 AM