SSIS job failure

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--------
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.
Who is Participating?
Alpha AuConnect With a Mentor Commented:
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.
krishna_harikAuthor Commented:
H iAlphaau,
I verified all the connections but I could not able to find that prob.

krishna_harikAuthor Commented:
I wants to know clear clarification regarding this error.
krishna_harikAuthor Commented:
Hi I attached the error message please check it and let me know what i sthe issue.

Thanks inn Advance.
Alpha AuCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.