Post reply

Building a UI For SSIS Package in VB.NET 2008

  • December 31, 2008 at 9:51 am

    #195543

    Hi all,

    Happy New Year before I get started....

    I have a project that will require a simple user interface that will collect some information from the user and then I would like to pass that info as variables to an SSIS package that will handle the rest of the job. The user interface will need objects that are not readily available in the Scrip Task components. My question(s) are below..

    1.) I know that you can access the SSIS namespace in VB.NET 2005 but it appears to possibly be different in VB.NET 2008. I'm looking for some advice on how to get this going.

    2.) Has anyone that is reading this ever done this before. If so can you shed some light on how you got it going?

    When I declare this variable below

    Dim App As New Applcation()

    I get an error message that say's this type has no constructor.

    I'm using the examples provide to me from the MSDN website.

    Thanks for your help.

    😀

  • December 31, 2008 at 10:15 am

    #919741

    Problem soved, I have found my answer.

    😀

  • December 31, 2008 at 3:06 pm

    #919841

    Great. What is the answer?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • January 1, 2009 at 7:32 pm

    #920067

    I assume it was either because:

    1. Applcation should have been spelt Application :p

    or (likely answer)

    2. You did not have a reference to the required assemblies and/or did not import the namespace where the SSIS Application class lives. If this is not done, it will default to using the System.Windows.Forms.Application class which correctly does not have a constructor.

    Happy New Year everyone!

  • January 2, 2009 at 10:30 am

    #920423

    That's right, I did not have the correct reference for my namespace. Once I got that corrected it's been smooth sailing.

    Thanks for the responses.

    😀

  • April 15, 2009 at 9:10 am

    #978156

    Could you please post the referneces and the codes which you used, so it would be helpful for all us who are searching for the answers, I am creating an UI for SSIS in .Net I am also passing the variable, if you give the references and the code it would be very helpful.

    Thanks.

  • August 17, 2009 at 7:16 am

    #1040160

    I want to build a VB 2005 UI where a non SQL Server user chooses the destination server, and a date for new records (new records added to the source database) and clicks a button to run the SSIS package. How did you accomplish yours?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply