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.