i am doing the following in a DTS package
Importing data from xcel into a temp table and then used a stored procedure to update the main table from the temp table.
But the problem is that sometimes the the xcel data might be errorneous eg one of the columns is a date field ,if date is not in proper format then the DTS inserts a null into the temporary table.IS there any way that i can trap this error when the process is running ??
If the date is invalid i just need to skip the record and write it to and error log file or ELSE abort the whole process with an email being sent to concerned person to fix the bad date.
Also i have a unique id field and in case this field contains a null or alphanumeric what can be done in that case??
Importing data from xcel into a temp table and then used a stored procedure to update the main table from the temp table.
But the problem is that sometimes the the xcel data might be errorneous eg one of the columns is a date field ,if date is not in proper format then the DTS inserts a null into the temporary table.IS there any way that i can trap this error when the process is running ??
If the date is invalid i just need to skip the record and write it to and error log file or ELSE abort the whole process with an email being sent to concerned person to fix the bad date.
Also i have a unique id field and in case this field contains a null or alphanumeric what can be done in that case??