Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3592
  • Last Modified:

How do I run an SSIS package from VBA application?

Hello Experts,

I have a VBA application that executes a SQL Server SSIS package. When it executes I get the this error (please see message box)

This is the code I'm using in my application:

Sub ExecutePackage()
    Dim oPKG As New DTS.Package
    oPKG.LoadFromSQLServer "MBC_Laptop", , , _
        DTSSQLStgFlag_UseTrustedConnection, , , , "MBC_Net"
    oPKG.Execute
    oPKG.UnInitialize
    Set oPKG = Nothing
End Sub

Please note that I can execute the package directly from the server. I can also execute it from VB.Net application using the following code:

    Sub RunSSIS()

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

        pkgLocation = _
          "D:\VB Projects\My Test Procedures\Import New Media Stats\Import New Media Stats\bin\Deployment\MBC_Net.dtsx"
        pkg = app.LoadPackage(pkgLocation, Nothing)
        pkgResults = pkg.Execute()

        Console.WriteLine(pkgResults.ToString())
    End Sub

Could someone please advise me how to run SSIS from VBA application
0
Mehawitchi
Asked:
Mehawitchi
  • 2
  • 2
1 Solution
 
MehawitchiAuthor Commented:
Here is the error message
error-message.jpg
0
 
PedroCGDCommented:
Dear Friend,
I've posted some time ago in my blog a post abou calling ssis package from an ASP application. Maybe it help you... check www.pedrocgd.blogspot.com

just a tip : Calling a SSIS package from a asp application from a ASP siet requires SSIS installed on websserver... in your case you must have SSIS installed in machine you have the excel file...

I hop it helps you!
regards
0
 
MehawitchiAuthor Commented:
Thanks Pedro,

You do have an interesting website, but unfortunately it does not help in my problem.

My problem is related to VBA not ASP.

On a separate note, I wanted also to go to BI Conference in Seatle, but couldn't afford. May be we meet next conference.

Cheers,
0
 
PedroCGDCommented:
The code in VBA and in ASP (VB.NET) is similar...
try it!
Leave a comment in blog to know you better and speak a little!
give feedback!
regards!!
Pedro
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now