Post reply

SSIS and VB.Net Application

  • September 15, 2011 at 1:38 am

    #244883

    Hi everyone

    I need to build an application that does the following:

    import records from an online mysql db into sql server (multiple sources)

    consolodate the orders and create a EDI XML file to send to a webservice

    consume the webservice

    update the correpsonding online mysql db's according to the webservice feedback

    the application will be a VB.net Windows Forms application that will be installed on computers that dont have any SQL 2008 client tools etc installed.

    Now a lot of these tasks can be accomplished with SSIS packages, but will I be able to run them from the VB.Net application, Im just worried about permission/driver problems etc. Or should I just code the data transforms etc directly in the application?

    Any ideas/comments would be appreciated.

    Thanks.

  • September 15, 2011 at 7:11 am

    #1381913

    You can have your .Net application start a SQL Server Agent job that runs the SSIS package(s). Create a SQL Agent service account on the server that has the appropriate permisisons.

    HTH,

    Rob

  • September 15, 2011 at 8:39 am

    #1382008

    Thanks for that Rob.

    So would you agree that it would be best practice to do this via SSIS and then call it from the VB app?

    Thanks again

  • September 15, 2011 at 8:49 am

    #1382029

    Not knowing many specific details, I'd say yes, use SSIS on the server to do the pieces that make sense there.

Viewing 4 posts - 1 through 3 (of 3 total)

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