Currently my SSIS package:
Grabs data from multiple servers and inserts it into a centralised server.
It has the following:
Execute SQL task:Holds the list of SQL servers from a SQL table in a variable.
Foreach loop container:Uses the above variable list to loop through using another variable.
Data flow task:Each time the OLE DB is dynamically updated it grabs some data from each of the server and dump it into the
centralised server.
How do I grab the @@servername from each of these servers and dump it into a table servers(servername varchar())
on the centralised server.So the idea is each time the source connection is updated dynamically I need to run
something like (select @@servername) on the server and grab the servername and insert the source servername into the
centralised server table servers(servername varchar()) .
Thanks