Executing DTS package from C #

[SP1709]

Hi,

we are executing DTS from C# using interop dll's
Interop.DTS.dll
Interop.DTSCustTasks.dll
Interop.DTSPump.dll

DTS are getting executed perfectly fine even data is getting transferred as required but the progress count shown in log file for all tasks is always 0 (zero).

Step 'DTSStep_DTSDataPumpTask_73' succeeded
Step Execution Started: 04/12/2006 12:37:54
Step Execution Completed: 04/12/2006 12:37:57
Total Step Execution Time: 3.172 seconds
Progress count in Step: 0


Executing same packages through command line command dtsrun.exe gives proper progress counts.

Please can anyone provide any suggestions/tips on this issue as if what can be done.

Thanks,
SP

 

[kmfna]

Hmm....are you executing all of this on the main thread? If so, it is possible that it is waiting for the function to stop and so not updating the progress. A thread is fairly linear, doing things step-by-step..usually when using a progress bar you need another thread that checks the progress.

Good luck!
-Kevin

- "The truth hurts, maybe not as much as jumping on a bicycle with no seat, but it hurts.

 

[SP1709]

Hi Kevin,

Yes we are executing this from main thread but the log files are created through dll's we use and we are not creating them.

Thanks,
SP