Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSIS job failure

Posted on 2009-07-16
5
Medium Priority
?
465 Views
Last Modified: 2012-05-07
Hi,
I am very new to SSIS now i am trying to execute one ssis package through job earlier that job ran and successed but from last three dayas onwards my job is failing wih below mentioned error I searched in goole but I could not able to find the at least relevent answer .
that is also business server so I have to troubleshoot that job ASAP.
please advise me and give me info how can i troubleshoot that job I have verified some configuration settings also also but I could not find exact reason for failure.

------------error message--------
Message
Executed as user: ABC\XYZABC Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  8:45:42 AM  Error: 2009-07-13 08:45:50.37     Code: 0xC001000E     Source: NaSoft_OrderProcessing      Description: The connection "{2A1514A2-74DC-46DD-A6F8-9907D056B9AA}" is not found. This error is thrown by Connections collection when the specific connection element is not found.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  8:45:42 AM  Finished: 8:49:28 AM  Elapsed:  225.203 seconds.  The package execution failed.  The step failed.
0
Comment
Question by:krishna_harik
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
Alpha Au earned 1500 total points
ID: 24875411
how you defined connection in the ssis package?

the error message is "the connection "{2A1514A2-74DC-46DD-A6F8-9907D056B9AA}" is not found."

you might need to check every connection in the package to find which one is it and solve the problem.
0
 

Author Comment

by:krishna_harik
ID: 24875913
H iAlphaau,
I verified all the connections but I could not able to find that prob.

Thanks,
0
 

Author Closing Comment

by:krishna_harik
ID: 31604144
I wants to know clear clarification regarding this error.
0
 

Author Comment

by:krishna_harik
ID: 24877415
Hi I attached the error message please check it and let me know what i sthe issue.

Thanks inn Advance.
SSIS-Error.docx
0
 
LVL 7

Expert Comment

by:Alpha Au
ID: 24891934
you can open the dtsx file with texteditor and use search for the text "2A1514A2-74DC-46DD-A6F8-9907D056B9AA" to identify what it related to.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question