I have a package that import several text files. What I need to do is check
for related records as I import the files. (i.e. cust# in order table exists
in the customer table), if there is an error, I need to create a report and
email it. I can use the lookup function (I assume) to check for the
existance of the related record, but how do I create the email? Should I
create an excel spreadsheet with the records in error and attach it to the
email?


Thanks

You can explore the following options:

a) If you need records for further analysis, the best way would be to
create the details in an excel file. Store it on a centralized folder on
the server.

b) For sending email, you can either use SQL Mail or explore other options
mentioned in the article below:

http://support.microsoft.com/default...312839&sd=tech

This email sending could be scheduled to run at specific time intervals or
a SP can be written to activate this email program whenever the error
occurs.

Hope that helps.

sanchans (AT) online (DOT) microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

yes, you could create a spreadsheet or even a text file and use the send
email task to email it.

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I can use the lookup function (I assume) to check for the
existance of the related record, but how do I create the email? Should I
create an excel spreadsheet with the records in error and attach it to the
email?

Hi,
I was wondering how you could use the LOOKUP to do this. Any help would be
appreciated.
Thanks in advance.

-Tash

"Tim Kelley" wrote:

Hello,
My task is similar to Tim Kelly's....In my package I'm trying to import
several tables. First I need to check for "NOT NULL" records as I import the
data. (i.e. my destination table column constraints are IS NOT NULL ).
During the transformation process Task if the source table contains a
NULLable field then I would like to send an exception report into a column in
the 'Exception_Table' . This exception should be one row of record. The field
this exception row of record is going into is (error_record). I have other
colums in the Exception_Table(package_description, Error_number,
transformation_name)

Thanks!

-Tash

"Sanchan Sahai Saxena" wrote: