Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > General .NET
|
General .NET For general discussion of MICROSOFT .NET topics that don't fall within any of the other .NET forum subcategories or .NET language forums.  If your question is specific to a language (C# or Visual Basic) or type of application (Windows Forms or ASP.Net) try an applicable forum category. ** PLEASE BE SPECIFIC WITH YOUR QUESTION ** When posting here, provide details regarding the Microsoft .NET language you are using and/or what type of application (Windows/Web Forms, etc) you are working in, if applicable to the question. This will help others answer the question without having to ask.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the General .NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 8th, 2006, 06:14 AM
Registered User
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to dan_code
Default Recognize errors using DTS.Package2 object

Hy guys.

I use dts.package2 object to execute a SqlServer DTS from my Vb.NET application. My DTS includes 3 SQL Tasks. If I have an error in one of them, the Execute method of dts.package2 object don't recognize some error, so my application continue. Now I read this topic:

http://p2p.wrox.com/topic.asp?TOPIC_ID=33898

I uderstood that, after executing the Execute method, I can look at the ExecutionResult property of every DTS.Step2 object of DTS.Package2 to recognize every error. My problem is that in my DTS I have 3 SQl Tasks, but oDts.Steps.count property of my object is valorized at 0. Why not 3? How to recognize errors during DTS execution?

Thank you in advance





Similar Threads
Thread Thread Starter Forum Replies Last Post
VB.NET: recognize errors using DTS:Package2 object dan_code SQL Server DTS 0 November 8th, 2006 06:16 AM
DTS Scheduled Jobs Errors Walden SQL Server DTS 10 March 16th, 2004 10:32 AM
DTS Scheduled Jobs Errors in DB (Misc) Walden SQL Server DTS 1 March 9th, 2004 08:13 AM
DTS Scheduled Jobs Errors in DB Walden SQL Server DTS 1 March 8th, 2004 11:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.