Hi all, I have a stored procedure (
SS2005) that uses a cursor to cycle on the records of a table to run - for each valid record - 3 SSIS packages. Something like this: WHILE @@FETCH_STATUS = 0 BEGIN select @Package1 = 'dtexec /f .......etc..... exec @returncode = master..xp_cmdshell @Package1 How can I keep track of the results of each package, to notify, at the end of the stored...