I get the following error message when i try to click on email task in DTS designer 2000

Error Source : Micorsoft Data transaformation Services (DTS) Package

Error DEscription : Cannot...

thanks,I wud like to know how can i show my result set of store proc as an attachemnt in the email

Osama

do u mean I cant do that in DTS, is it possible only in sql 2005

13/34/2007 is not a valid date, need to check like this.

its not the exact date i need to check rather i want to check the format

If its a staging table from where i'll be importing gud data into my Db, how can i handle the left over wrong data in staging table, how can i...

this will be a sheduled job and i will be emailing them errors occured everyday.

since i have no control on user entryi have to some have send mesg to the...

How about checking each field for error and pop up a message of that error. I have 20 fields where i need to check for errors. I wud liek to...

yes, but we do not have any control over the user application, the client bought it from different vendor and we are supporting database. we have created another database for...

I just want to insert id field and the error field into the temp table, want to join 2 tables which has error and the 2 tables will be having...

I do have 2 tables where i need to find for errors and display a resut set. From the 2 tables there are fields more than 20 which may have...

Exactly, this will be on sheduled basis but i dont want to use a table to track my errors, as and when I run this proc before import I shud...

Actually i want check these errors before importing data into different DB, if i find erorrs I want to display those in my result set and ask the users to...

I am looking into certain fields for the right data, something like date field shud contain only after the year 1980 or a character field chud have either A/B/C else...

I think

we can add a constraint for that field with expression columnname='CAT' and un check the box where it has " check for existing data"

how is tht?