>Hi All,
> How can I execute a dts package with a global variable from vfp?
>

Take a look at http://www.sqldts.com/default.aspx?208. The example is in VB and I'm not sure if it can be adapted to work in VFP but you're free to try.
You can also check http://www.databasejournal.com/features/mssql/article.php/1459181