dbTalk Databases Forums  

DTSPackage

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


Discuss DTSPackage in the microsoft.public.sqlserver.dts forum.



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

Default DTSPackage - 06-22-2006 , 05:14 PM






I am running a DTSPackage in dotnet using the COM Microsoft DTSPackage
object. I believe I can log results to the NT log, but is there any way to
give immediate status to the user of errors? What would be great is to show
the number of rows that are being copied using the COM object. Is this
possible?

I have not yet tried the DTSRun utility, but I was told that shows progress
with a graphical display. I would go this route but there seems to be a lot
of files to install, and using the COM object with the Wise installer seems
to do it all automatically.

Suggestions to show feedback to the user, and possibly the number of rows
being copied?

Derek



Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: DTSPackage - 06-25-2006 , 04:48 AM






Hello Derek,

To get real-time feedback for your program you would need to use events.
These include progress events such as rows transferred.

If you can why not just use the existing tools, for examle DTSRunUI, not
the UI bit there.

Darren

Quote:
I am running a DTSPackage in dotnet using the COM Microsoft DTSPackage
object. I believe I can log results to the NT log, but is there any
way to give immediate status to the user of errors? What would be
great is to show the number of rows that are being copied using the
COM object. Is this possible?

I have not yet tried the DTSRun utility, but I was told that shows
progress with a graphical display. I would go this route but there
seems to be a lot of files to install, and using the COM object with
the Wise installer seems to do it all automatically.

Suggestions to show feedback to the user, and possibly the number of
rows being copied?

Derek




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.