sql2005 dtexec how SSIS are run
first of all, in the Business intelligence design package, and debugging throughTwo Select the DTExec tool to run the package(i) open the xp_cmdshell option The xp_cmdshell option introduced in SQL Server 2005 is a server configuration option that enables system administrators to control whether xp_cmdshell extended stored procedures can be executed on the system. By default, thexp_cmdshell option is disabled on newly installed software, but it can be enabled by using the Perimeter Application Configurator tool or by running the sp_configure system stored procedure, as shown in the following code example: N to allow advanced the options to be changed.n EXEC sp_configure ' show advanced options ', 1 go–N to update the currently configured value for advanced options. Reconfigure go-to enable the feature. n EXEC sp_configure ' xp_cmdshell ', 1 go–N to update the currently configured value of this feature. Reconfigure Go(ii) Implementation of packages using dtexec utility Tools DTExec Use Way please refer to:http://msdn2.microsoft.com/zh-cn/library/ms162810.aspxWay One: directly by allowing SSIS file execution Use the following command:xp_cmdshell ' dtexec/f ' C:\UpsertData.dtsx 'mode two: first to import the package into SQL 2005 in the execution1) Import PackageSQL2005 Open managemenet Studio, select Integration Services, select
"Stored Packages"-"MSDB", right-import packages, select File systems, specify packages with business Intelligence Development Studio, select ImportNote: The protection level option needs to choose to rely on server storage and roles for access controlOtherwise, an error occurs when the package is run via dtexec -Note: The Protected XML node "Dts:password" cannot be decrypted and the fault is 0x8009000b "This item is not suitable for use in the specified state. ”。 You may not have permission to access this information. This error occurs when there is a cryptographic error. Make sure that you provide the correct key. Please seehttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=142920&SiteID=12 After the import is complete, you can execute the statement in Managemenet studioxp_cmdshell ' Dtexec/dts ' \msdb\wangluo "/server" Xxw2006_1 "/maxconcurrent"-1 "/checkpointing off/reporting V"