Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 536
  • Last Modified:

SQL Server 2005 Job with SSIS package as STEP ....

Hi,

I am working on SQL Server 2005 with SSIS. I have cretaed a SQL Server Job having a step with SSIS package. The package will not do anything except that it loads data from TXT file with necessary columns and dumps into SQL Server 2005 database table.

My intention is...while it is trying to load data from TXT file to database table, if any error occurs (Ex: May be because of datatype mismatch) then i want to see 1) What is the error 2) At which record the error has occured and i want to have a notification email to me with this necessary information.

Can you please provide me steps to do this task ? If you can provide me details how we can achive this by code is much appreciated. Appreciate your help !

Thanks
0
kishore_peddi
Asked:
kishore_peddi
1 Solution
 
pssandhuCommented:
First you will need to create a database mail profile.
http://www.databasejournal.com/features/mssql/article.php/3626056

After you have successfully done the above you can then go into your job properties and set up an email notification everytime the job executes. But to start with it will take a bit of an effort to set the DB Mail if this is your first setting it up. Refer to the link and ask where you get stuck.

Cheers!
0
 
kishore_peddiAuthor Commented:
Hi,

I did this job - DB Email. Can you please explain how can i get my information

1) What is the error
2) At which record the error has occured

Please remember that my job step is having Package only. And we need to track if something happens in that package - while loading from TXT file to table.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now