Link to home
Start Free TrialLog in
Avatar of gogetsome
gogetsomeFlag for United States of America

asked on

SSIS package error

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)

Avatar of matrix_aash
matrix_aash
Flag of United Kingdom of Great Britain and Northern Ireland image
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.

Aash.
Avatar of ibrusett
ibrusett
Flag of Italy image
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
Avatar of gogetsome
gogetsome
Flag of United States of America image

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of wittyslogan
wittyslogan
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial