>We are moving up from a SQL 2000 server to SQL 2008 R2 (64 bit).
>
>I'm currently using COM/OLE Automation from VFP9 to drive DTS packages.
>
>Can I import those DTS packages into SQL 2008 and COM/OLE automate them from VFP9?
>
>Or can I create SSIS packages and automate those from VFP9?
>
>Thank you!
You can create SSIS packages and set up a job to run them. VFP doesn't seem to come into the picture at all.
If it's not broken, fix it until it is.
My Blog