Pauls Blog

https://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

xp_cmdshell allows you to run shell commands from T-SQL Instructions on enabling xp_cmdshell are found at  https://msdn.microsoft.com/en-us/library/ms190693.aspx -- To allow advanced options to be changed. EXEC sp_configure 'show advanced options', 1; GO -- To update the currently configured value for advanced options. RECONFIGURE; GO -- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1; GO -- To update the currently configured value for this feature. RECONFIGURE; GO

http://www.w3schools.com/sql/func_convert.asp

      public static XmlDocument ConvertToXmlDocument(XDocument input)       {          var xmlDocumentObj = new XmlDocument();          using (var xmlReader = input.CreateReader())          {             xmlDocumentObj.Load(xmlReader);             return xmlDocumentObj;          }       }

https://technet.microsoft.com/en-us/magazine/hh289310.aspx

It's something like this Write - Host "$($blah.Name) $($ blah .Desc) "

nable Remote Desktop and add this domain user to Remove Desktop Users group.   http://technet.microsoft.com/en-us/library/cc794832(WS.10).aspx Enable "Allow log on locally" and add this domain users.  http://technet.microsoft.com/en-us/library/cc785165(WS.10).aspx Delegating administration http://technet.microsoft.com/en-us/library/cc778807(WS.10).aspx