Progress bar use with SSIS package

[jpack23]

I have a section of code executing a SSIS package

Module DataImport

Public Sub LoadData()

Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult

pkgLocation = _
"C:\Users\Me\Documents\Visual Studio 2005\Projects\SSISTest\Integration Services Project1\Package4.dtsx"
pkg = app.LoadPackage(pkgLocation, Nothing)
pkgResults = pkg.Execute()

This process takes a minute or two and I would like a progress bar for the user to see. I would love to have the progress bar keep up with the data load, meaning when it has loaded half the data the progress bar is at 50% (1st priority is just getting a progress bar to appear and move even if it doesn match the actual percentage of the data load)


any help would be greatly appreciated

thank you

joe

 

[jebenson]

The following link describes how to set up an event listener class and capture events from the SSIS package. The text says that one of the things you can capture is the packages progress, but the example does not cover that particular event.

http://msdn2.microsoft.com/en-us/library/ms136090.aspx

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!