Howes-IT-Going - SQL Server SSIS Package Variable Update
via xp_cmdshell Outside BIDS/Visual Studio




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

Save As xp_cmdshell_ssis_cmd.sql

Go Back to:
http://Howes-IT-Going.com

This Webpage and Contents Created by Steven C. Howes © Howes-IT-Going 2008-2012 All rights reserved.