Error after importing DTS package to sql 2005 legacy

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » Error after importing DTS package to sql 2005...

Error after importing DTS package to sql 2005 legacy

Rate Topic

Display Mode

Topic Options

Author

Message

jdbrown239

Posted Tuesday, January 29, 2013 11:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:35 AM
Points: 112, Visits: 212

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 »

Permissions