Solved

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

Posted on 2007-11-28
2
510 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
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now