>I am trying to import a large table from a Visual Foxpro system [1.5GB]. When I try to view the Transformations tab on a DTS package, it sits for several minutes and finally gives an error. Won't let me view the tab to set transformations. Is there another easy way to import data from the VFP table? Is there a way to view the code behind the DTS package and maybe I can transform via the code rather than the wizard.
>
>Thanks,
>Doug
Last question first. You should be able to save the DTS package as a VB project and look at it that way. What exactly is the error message?
As far as moving data from VFP to SQL Server, there are lots of options here. Depends on the nature of the transformations that you need to do. Simplest, of course, is a straight dump - column names and types match. DTS is super-fast for this. For complex stuff, I've found that writing a SQL SP and then using DTS to hand the data off to that works pretty good. Usually a lot faster than doing the lookups and data massaging in DTS.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
