[Execute Process Task] Error: In Executing "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" " /FILE "\\140.131.12.25\Work\Platform\Db\SSIS\TABLE_LOAD.dtsx" /SET \Package.Variables[User::controlCount].Properties[Value];"0" /SET \Package.Variables[User::fileID].Properties[Value];"1" /SET \Package.Variables[User::filePathName].Properties[Value];"\\140.131.12.25\work\_data_inbox\DHM\Compliance\Work\test.txt" /SET \Package.Variables[User::archivePath].Properties[Value];"\\140.131.12.25\work\_data_inbox\DHM\Compliance\Work\Archive\" /SET \Package.Variables[User::stageID].Properties[Value];"24" /SET \Package.Variables[User::MasterExceptionPkg].Properties[Value];"" /Conn OH_STAGE;Provider=SQLNCLI10.1;Server=140.131.12.25;Database=OH_STAGE;Trusted_Connection=yes;" at "", The process exit code was "6" while the expected was "0".
/FILE "" /SET \Package.Variables[User::controlCount].Properties[Value];"0" /SET \Package.Variables[User::fileID].Properties[Value];"23" /SET \Package.Variables[User::filePathName].Properties[Value];"" /SET \Package.Variables[User::archivePath].Properties[Value];"" /SET \Package.Variables[User::stageID].Properties[Value];"26" /SET \Package.Variables[User::MasterExceptionPkg].Properties[Value];
DECLARE @SQLQuery AS VARCHAR(2000) Declare @param1 varchar(200) Declare @param2 varchar(200) Declare @param3 varchar(200) Declare @param4 varchar(200) Declare @param5 varchar(200) Declare @param6 varchar(200) SET @SQLQuery = 'DTExec /FILE "\\140.131.12.25\Work\Platform\Db\SSIS\TABLE_LOAD.dtsx" /DECRYPT "Password1"' set @param1=' /SET \Package.Variables[User::controlCount].Properties[Value];"0"' set @param2=' /SET \Package.Variables[User::fileID].Properties[Value];"23"' set @param3=' /SET \Package.Variables[User::filePathName].Properties[Value];"\\140.131.12.25\work\_data_inbox\DHM\Compliance\Work\test.txt"' set @param4=' /SET \Package.Variables[User::archivePath].Properties[Value];"\\140.131.12.25\work\_data_inbox\DHM\Compliance\Work\Archive\"' set @param5=' /SET \Package.Variables[User::stageID].Properties[Value];"26"' set @param6=' /SET \Package.Variables[User::MasterExceptionPkg].Properties[Value];""' SET @SQLQuery = @SQLQuery+@param1+@param2+@param3+@param4+@param5+@param6 EXEC master..xp_cmdshell @SQLQuery GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)