I ran the job and to execute a SSIS dts package in sql 2005 server, I got the following error message:
Thanks for your help!
Date 1/25/2008 4:52:00 PM
Log Job History (Survey Returned Weekly)
Step ID 1
Job Name Survey Returned Weekly
Step Name Survey Returned Weekly
Sql Severity 0
Sql Message ID 0
Operator Net sent
Retries Attempted 0
Executed as user: GSB\sqladmin2000. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:52:00 PM Progress: 2008-01-25 16:52:00.74 Source: Copy Data from Results to Sent Task Validating: 0% complete End Progress Progress: 2008-01-25 16:52:00.74 Source: Copy Data from Results to Sent Task Validating: 33% complete End Progress Error: 2008-01-25 16:52:01.27 Code: 0xC0202009 Source: Survey Returned Weekly Connection manager "Connection 2" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2008-01-25 16:52:01.27 Code: 0xC020801C Source: Copy Data from Results to Sent Task OLE DB Destination  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONM... Process Exit Code 1. The step failed.