Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using SSIS to convert VFP table to SQL Server

Status
Not open for further replies.
mjk9564

mjk9564

Programmer
Apr 23, 2003
64
US
I’m trying to use SSIS to convert Foxpro to SQL Server. I have an ADO connection setup and a Data Reader reading the VFP data and a Data Conversion object to set all the data to the correct data types. The problem I’m having is with Memo fields they all are set to Null in SQL Server. When I use a Data Viewer to view the data it only says “<Long Text>”. Does anyone know how to bring over memo fields?

Thanks!
Matt

P.S - I'm using text stream [DT_Text] for the memo field.
 
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
165
petart
petart
ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
205
gk53
gk53
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
302
markjoseph1232
markjoseph1232
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
155
botatun
botatun
okcorral
  • Locked
  • Question
insert in to DB2 Z/vse via SQL 2005 linked server
Replies
1
Views
177
okcorral
okcorral

Part and Inventory Search

Sponsor

Back
Top