June 13, 2010 at 8:02 pm
The solution is at http://www.sqlmag.com/article/sql-server-integration-services-ssis/use-ssrs-and-ssis-to-create-a-dba-repository.aspx and it works but I have added a new item based off one that was working. I just change the SQL query and added a new table to hold the results
Error 18 Validation error. Populate_DBA_REP Connection manager "MultiServer": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Named Pipes Provider: Could not open a connection to SQL Server [2]. ". Populate_DBA_REP.dtsx 0 0
I need to get this resolved and find out what I did wrong so I can add new items as needed
Willing to pay for support if that is what it takes to fix this.
June 14, 2010 at 6:44 am
Just looking at the error, it looks like a data source problem.
Try defining a new data source and see if that works.
Also - are you the only one working with the package?
Make sure you review the package security model and understand what the different modes do.
We usually put a password on the package when stored on the file system.
Greg E
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply