>>>>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?
There are several ways to do it:
http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspxIf you have SSIS on the same box, if you need to pass a parameter, if you need to return data..all those things dictate which way you'd want to do it.
ICQ 10556 (ya), 254117