dbTalk Databases Forums  

Handle packages error(in SQL Server) from C#.NET

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Handle packages error(in SQL Server) from C#.NET in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Almaei
 
Posts: n/a

Default Handle packages error(in SQL Server) from C#.NET - 08-07-2004 , 06:55 AM






Hi
I want handle package errors in my program with C#.NET.
but,
I can call one a package (within SQL Server) from C#.NET (with in my
Application), but I can not handle it's errors.
My packages Import Data from file to table and I built it from
"Import/Export Data Wizard".
(( Excuse me, my English is not good!Help me,please))
Regards, Almaei

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Handle packages error(in SQL Server) from C#.NET - 08-07-2004 , 07:11 AM






So what you will need to do is use the DTS object model and Events.

Gert has some cool stuff here

http://www.sqldev.net/dts/ExecutePackageWithEvents.htm

Also check out

http://support.microsoft.com/?kbid=319985

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Almaei" <Almaei (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi
I want handle package errors in my program with C#.NET.
but,
I can call one a package (within SQL Server) from C#.NET (with in my
Application), but I can not handle it's errors.
My packages Import Data from file to table and I built it from
"Import/Export Data Wizard".
(( Excuse me, my English is not good!Help me,please))
Regards, Almaei



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.