Matt Wilhoite (8/6/2009)

---

I am not sure this is what you are looking for but here it is: Let me know if you need this in a different format.

//EDIT Also,...

I wrote this query but it goes row by row:

IF ( members.recipid = memcaid.recipid)

BEGIN

IF(members.royalid IS NULL)

BEGIN

UPDATE members

SET members.royalid = CAST(memcaid.membid AS varchar(12))

END

ELSE

BEGIN

IF(members.royalid CAST(memcaid.membid AS varchar(12)))

BEGIN

PRINT 'Mismatch';

END

END

END

Should I do this...

Hello,

Thanks for the help but I am giving up on this. Its already taken a lot of my time. I will try to clean up the data on FoxPro side

Thanks

Jack Corbett (8/4/2009)

---

It would be something like this (I might not have it perfect):

[bit_val]==False ? Null(DT_BOOL) : [bit_val]

If the datatype of the bit column is bool you may have to...

Jack Corbett (8/4/2009)

---

I don't know if you can do this with FP 2.6, but using the OLEDB provider you may be able to do a select statement as your source...

rmechaber (8/4/2009)

---

Looks like says that FoxPro 2.6 uses blanks, not a NULL token, and that later versions of Visual FoxPro have columns whose NULL values will import in SQL...

Jack Corbett (8/4/2009)

---

Your destination table will not accept a null value, that's what NOT NULL means in a table definition. So if you explicitly try to insert a NULL...

novice_coder (8/3/2009)

---

hmm Beacsue I read somewhere on the...

hmm Beacsue I read somewhere on the internet...

BTW, I am not using Import/Export wizard. I am building a SSIS package and for source I am picking OLE DB Source and for the Provider in connection Manager, I...

Allister Reid (8/3/2009)

---

Hi,

I just tested a SSIS import of a Foxpro free table, with integer and logical fields, both nullable. I added a few rows of data leaving a...

Jack Corbett (8/3/2009)

---

Are you changing anything in the database schema or just "copying" the tables and data to SQL Server? It should be fairly straitforward if you are copying...

rmechaber (8/3/2009)

---

As for verification, that's a general question others may have suggestions about. General stuff like number of rows imported is basic. Does your import routine catch and...

Hello rmechaber,

Thanks for the information. Yes, I have managed to migrate the data using SSIS but I am facing problems with Logic/Bit fields. In my FoxPro table these fields have...

haha thanks Jeff. Yeah, I have been acknowledged by my professors and managers in the past for my coding skills. Hopefully I will become as good as you guys in...