SQL Server SSIS Package Variable Update via xp_cmdshell Outside BIDS/Visual Studio
The following example shows how to create your own SQL Server stored procedure to update an SSIS Package Variable using the sys master xp_cmdshell.
You will need to have SQL Server 2008 and SSIS installed, .dtsx package experience And a text editor like: Notepad, TextPad or Wordpad.
Use the xp_cmdshell_ssis_cmd.txt file contents to create the needed SQL stored procedure for this example. You will need master database access to execute this. Always make
Backup copies of all files before editing! Use this script At Your Own Risk!
xp_cmdshell_ssis_cmd.txt
Go Back to: