SSIS Package fails with no description why it failed?

Question

SSIS Package fails with no description why it failed?

mandavli

SSCrazy

Points: 2122
More actions
November 15, 2011 at 12:22 pm

#260039

I am getting message on SQL
server Message
Executed as user: The package execution failed. The step failed.
I donot what is wrong with package as not other details I find it in history.
Can any one help?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 1

mandavli (11/15/2011)
I am getting message on SQL
server Message
Executed as user: The package execution failed. The step failed.
I donot what is wrong with package as not other details I find it in history.
Can any one help?

Is that the error message from the SQLAgent job? Do you have step logging turned on for the step that runs the package? If so, go into that and take a look at the details of the package run.

If not, go turn that on. 🙂

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

mandavli SSCrazy Points: 2122 More actions · Answer 2

under Step ID it shows 0 and that is message it shows.

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

mandavli (11/15/2011)
under Step ID it shows 0 and that is message it shows.

Sorry, apparently I wasn't clear. you should have a better description if you expand the node and review step 1, and even more if you go to the output file.

In the step list, go into your steps:

Then find the file in the large highlighted circle. That should have a stronger description and a list of everything that occurred throughout the package's execution. If it's not currently outputting to a file, output to it.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

mandavli SSCrazy Points: 2122 More actions · Answer 4

When I click on advanced tab under SQL Server Integration Service Package it shows No options for this command type