Post reply

Can I call a Visual Foxpro 9.0 ".exe" from inside of a SQL Server 2008 SSIS Script Task?

  • February 13, 2011 at 3:11 pm

    #245460

    I have some Visual Foxpro .exes that perform a great deal of work on SQL Server data sets. I would like to call these .exe's from inside a SSIS Script Task or Script Component and would like to know if anyone has done this. I can also compile the Visual Foxpro program to a COM object, so if you know how to call a COM object or .exe, this would help. I just happen to be using Visual Foxpro Version 9.0 .exes.

    It is my objective going forward to advance my VB.Net or C# ,Net skills to the level that I can rewrite/replace the Visual Foxpro .exes with VB.Net or C# .Net code, but for now, I'd just like to be able to call an .exe or COM object from within the SSIS Script Task or Script Component.

    Any assistance would be appreciated.

    Thanks....

  • February 14, 2011 at 6:21 pm

    #1286813

    SSIS does have an Execute Process Task, so if you're working with .exe's you might be able to run them that way. You probably won't be able to get much output from the process however.

  • February 15, 2011 at 9:04 am

    #1287127

    Thank you for the input ZZartin. I will look at that Task.

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

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