SSIS and VB.Net Application

Question

SSIS and VB.Net Application

Jako de Wet

Hall of Fame

Points: 3123
More actions
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.

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

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

rgtft Hall of Fame Points: 3518 More actions · Answer 1

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

Jako de Wet Hall of Fame Points: 3123 More actions · Answer 2

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

rgtft Hall of Fame Points: 3518 More actions · Answer 3

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