January 16, 2008 at 9:21 am
I have a simple package and its returning the following error messeges.
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at DTSTask_DTSDataPumpTask_1 [OLE DB Destination [28]]: The AcquireConnection method call to the connection manager "Microsoft OLE DB Provider for SQL Server" failed with error code 0xC0202009.
Error at DTSTask_DTSDataPumpTask_1 [DTS.Pipeline]: component "OLE DB Destination" (28) failed validation and returned error code 0xC020801C.
Error at DTSTask_DTSDataPumpTask_1 [DTS.Pipeline]: One or more component failed validation.
Error at DTSTask_DTSDataPumpTask_1: There were errors during task validation.
Error at Load Daily Manifest [Connection manager "Microsoft OLE DB Provider for SQL Server"]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.".
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
Does anybody have any idea about these error messages? Any help would be highly appreciated..
Thanks
January 16, 2008 at 9:42 am
The problem appears to be that whatever address or alias was used to create the OLE DB connection can't be resolved from where the package is executing. Maybe it was set up using (local) or something. Maybe the server doesn't allow TCP/IP connections (the default for SQL Server 2005).
My Blog:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply