DT_BOOL loading "FALSE" for empty record

Question

Hi There,

I am trying to load FoxPro tables to SQL server using SSIS (I am using Visual Studio 2015 for ingratiation services).

While performing loading task, I got stuck in between with DT_BOOL and DT_NUMERIC datatypes.

Find the below explanations of the issues I am facing:

• Issue with DT_BOOL & DT_NUMERIC datatype:

Consider I am loading below FoxPro table to SQL server, where field "Name" is [DT_STR], field "Serial_num" is [DT_Numeric] and field "Permission_rev" is [DT_BOOL] datatype. the foxpro table got EMPTY RECORDS in it(Second row in below table)

FoxPro_table

Name	Serial_num	Permission_Rev
Mr.Jack	112	True
Mr.Adam
Mr.Brad	113	True
Mr.Ethan	114	False

I used Data-flow task for loading this table. That is in Dataflow task I used OLE DB source to extract FoxPro Table and populate this table to SQL Server using OLE DB destination, when task is finished. Below mentioned table will be populated into SQL Server.

SQL_Server table

Name	Serial_num	Permission_Rev
Mr.Jack	112	True
Mr.Adam	0	False
Mr.Brad	113	True
Mr.Ethan	114	False

Here we can see second row in the target table (SQL Server table), where it is Populated with "0" and "False" for empty records.

My requirement is, It should load as it is in Source table(i.e., EMPTY RECORD to EMPTY RECORD) but unfortunately for DT_BOOL and DT_NUMERIC for empty records it is defaulting the values.

I also tried using derived column, but my try was unsuccessful, I observed that in OLE DB source itself the empty record value are getting loaded with default values.

Kindly provide a solution in such way that I can load empty record to target table for DT_NUMERIC and DT_BOOL datatypes.

Thanks

MANJUNATH

Answer 1

Hi Manjunath,

Incorrectly configured settings and error in the data source are a few of the possible reasons why you are experiencing issues loading tables to SQL Server using Integration Services. Since you’re using the SQL Server Integration Services, it is best that you post your concern to our MSDN Forums. It’s a community of network developers who can best address your concern.

If you have other questions, feel free to reach out to us.