Problem: We have a table called t_serverdetails, which have all the production server names stores in it. Now we want to extract each server name from the table and connect to the server using Dynamic connection and run the script which we have already created to extract information (Like user privileges etc.) and result should be store in local table called t_result. As we are migrating to sql 2005, So wanted to use SSIS. I am new to SSIS.
Thanks in Advance.