Solved

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

Posted on 2007-11-28
2
522 Views
Last Modified: 2011-09-20
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
Comment
Question by:kishore_peddi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 20371029
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
 

Author Comment

by:kishore_peddi
ID: 20371077
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

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question