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
Posted Tuesday, January 29, 2013 11:00 AM



Group: General Forum Members
Last Login: Thursday, September 10, 2015 6:08 AM
Points: 152, Visits: 330

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