SSIS package error

Posted on 2007-10-17
Last Modified: 2008-01-09
Hello, I'm new to SSIS and have created my first package. It was working fine until I tried to deploy it and have it execute at a specific time each day. I now get this error and the package fails:

Warning      1      Warning loading WebsiteUpdate.dtsx: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed.        \\qualcast\users shared folders\administrator\my documents\visual studio 2005\projects\websiteupdate\WebsiteUpdate.dtsx      1      1      

What does this mean and how can I get back to it working at least manually?

Some more information:

Unexpected internal error: Invalid state for operation. (Microsoft Visual Studio)

Program Location:

   at Microsoft.DataWarehouse.ProgrammingByContract.State.NullCheck(Object obj)
   at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, DataWarehouseProjectManager manager, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)

Question by:gogetsome
    LVL 8

    Expert Comment

    Have you verified the path of the package making sure it's ok. It looks like the path has been changed for the package.

    To run it manually you can use the .dtsx file and it will do the job.

    LVL 3

    Expert Comment

    If you are scheduling package using SQL Agent, make sure that the account with which the SQL Server Agent starts has the correct permissions (read and execute should be enough) on the folder where there is the .dtsx file

    Author Comment

    I do not know what I have done with the package trying to schedule it, but I do not even get a green arrow to execute the package even when I create a new project.
    LVL 7

    Accepted Solution

    Open the package in SSIS and click on the package explorer tab.
    You should then open up connection manager
    In there you should see some connections.
    You need to open them uo and see if the connections make sense:
    Is the data source correct? (if you have moved this from development to live you may find that the data source is still development)
    Is The package looking at the correct object?
    Is the security set correctly?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    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.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now