I am running my DTS in a batch file using the DTSRUN utility.
This DTS will be run by users so I need to make sure that if the DTS
does not runs properly
it should prompt the user with an error.
Is there any way to do this within batch file using any command. Right
now I am printing on the
screen for users to check for error messages, but if there is error
will there be a way to print those errors. The user will press any key
The package can only be run once in a day successfully as it copies
data from one table to another and there are primary key constraints.
So the package will not run if trying to insert duplicate data which
already exists in the table.
This is my batch file.
dtsrun /Smyservername /Umyusername /Pmypassword /Nmypackagename
ECHO CHECK FOR ERRORS. Notify Database Team in case of Errors.
Is there way to warn users if the DTS did not succeed or generate
atleast one error.