kishore_peddi
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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