Wednesday, June 04, 2008

Visualizacion del codigo de retorno de la ejecucion de un paquete integration

Codigo obtenido a partir de la ejecucion via query desde una sentencia sql
http://technet.microsoft.com/en-us/library/ms162810(SQL.100).aspx


DECLARE @returncode int
EXEC @returncode = xp_cmdshell 'dtexec /f "C:\UpsertData.dtsx"'

Value Description
0 The package executed successfully.
1 The package failed.
3 The package was canceled by the user.
4 The utility was unable to locate the requested package. The package could not be found.
5 The utility was unable to load the requested package. The package could not be loaded.
6 The utility encountered an internal error of syntactic or semantic errors in the command line.