Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error after importing DTS package to sql 2005 legacy Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2013 11:00 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 4, 2014 8:05 AM
Points: 133, Visits: 283
Hi

I imported a DTS package from the file system to msdb. The package runs fine from the package utility but when I use a sql agent job I get the following error:

Could not load package "\New Dlr Status Import clean" because of error 0xC001000A. Description: The specified package could not be loaded from the SQL Server database. Source: Started: 6:10:01 AM Finished: 6:10:01 AM Elapsed: 0.75 seconds. The package could not be loaded. The step failed.

Note: When I try to manually locate the package when setting up the job I am unable to see it in msdb or package store.

Any help would be appreciated.
Post #1413200
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse