Samuel

Depending on your business requirements to import/export data, consider the alternative approach of using data-based logic.

I have personally found using control logic within the data (in control sqlserver tables) to be very useful.

In this approach
a) create and populate a control table with the logic to determine whether a dts package to go ahead or not.
b) populate the control table with the necessary dependencies.

You can create then a series of dts packages that polls the control table and if the logic says "go ahead" then it will carry out the dts import/export.

This control logic could be
c) presence of an operating system file and/or its timestamp
d) value in control table values.

Your trigger for the control tables then could be externalised for instance updating some control values in (d) or creating a file object in (c)

With a suitably designed system, your data import/export can run end-to-end without human intervention, or with user-triggered values to kick-off the appropriate dts packages.

Tau






>Hi all,
>I have created a DTS package to transfer data in Local Packages of SQL Server.
>I wish to call and run it programmatically from my VFP application.
>besides use set time schedule, any other method to call it? such as use EXEC command
>to execute the package name, is it possible?
>thanks for any help.