>>>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.
>
>You can run SSIS packages from VFP though - I think that's what he was asking????
How you can run them from VFP?
If it's not broken, fix it until it is.
My Blog