?
Solved

SSIS job failure

Posted on 2009-07-16
5
Medium Priority
?
463 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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 video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
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…

752 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