In my SSIS package I am trying to loop the database servers to get the information. I have defined the variable and assigned server name to it, I am able to test it using script task in For Loop Container. I have created a connection
Manager called MultiServer and passing the ServerName Variable thru Expression as @[User::SRV_Conn]. When I click evaluate expression, it is showing as 0. Now in Data Flow I selected a new OLE DB Source and when I try to select MultiServer I am getting
error Hresult:0x80004005 Server is not found or not accessible. For testing purpose I have created the OLE DB for the error server and it works fine. Not sure what I have missed. I used
http://www.simple-talk.com/sql/ssis/using-ssis-to-monitor-sql-server-databases-/ and trying to do the same. Please help me. Thanks.
View Complete Post