dbTalk Databases Forums  

Import Foxpro v8 data with SSIS?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Import Foxpro v8 data with SSIS? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Paschott
 
Posts: n/a

Default Import Foxpro v8 data with SSIS? - 05-03-2006 , 12:13 PM






Trying to import FoxPro files from version 8. I think I've got the
latest oledb drivers, but they don't seem to work with SSIS. I am able
to use them just fine with DTS.

Tried importing database file and individual files from the directory.
Neither one works.
Keep getting a "Parameter is Incorrect" error.

Any ideas on what to look for? Anyone have any experience with this?

Thanks.

-Pete Schott


Reply With Quote
  #2  
Old   
Paschott
 
Posts: n/a

Default Re: Import Foxpro v8 data with SSIS? - 05-03-2006 , 02:00 PM






OK - did some checking on the MSDN site and found that this is an issue
with the Wizard and SP1 (CTP and release). I've found that this can be
done by creating the source connections manually in the BIDS. Not
nearly as convenient as being able to select the database and import
columns, but it works.

Guess I'm waiting for either a hotfix or SP2 now. :-(

-Pete


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.