I am using XML configuration files for SQL Server OLEDB connections in a SSIS project. I created the solution on my machine and it works in Visual Studio and when I run it from a SQL Server Agent job on my machine. When I promote the packages
to a server and change the server name in the XML Configuration files, the solution fails with the error message below. What I do not understand is the parent package connects fine. The problem occurs in the child package. I do have Delay
Validation set to True for the package and the connections. Has anyone run across this issue before?
SSIS Error Code DTS_E_OLEDBERROR. 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.".
View Complete Post