Solved

SSIS job failure

Posted on 2009-07-16
5
461 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 500 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL query with cast 38 61
SQL Server Insert where not exists 24 52
SQL Error - Query 6 50
Applying Roles in Common Scenarios 3 22
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

730 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