You can use DTS automation from VB or VFP.
This way you can customize the properties of your package and objects.
I dont remember what the dll is called, but you should see it in references under Microsoft Sql Server.

Vlad