• Our DBA went with the dtexec method with a config file.

    http://msdn.microsoft.com/en-us/library/ms162810%28v=sql.105%29.aspx

    You put the SSIS packages and configuration files in folders on the server and create a batch file referencing the package and config file of the form:

    "c:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTEXEC.exe" /File "\\Server\SSISPackages\Packages\SSIS_Package.dtsx" /Conf "\\Server\SSISPackages\Configs\SSIS_Package.dtsConfig" /CHECKPOINTING OFF /REPORTING D

    SQL Server has to be installed on the workstation from which the batch file is executed.