Date datatype issue in SSIS

(0) Share

Report

Posted on by GPrasanna

140

I am working on data integration between DB2 and SQL server using SSIS package. From SQL query I am fetching the records and doing a lookup on DB2 data query where i have mapping on a column which is of Date datatype. In SQL the field is of date datatype but in DB2 it is always returning as a string. I tried converting the field to Date in DB2 but still it returns as string. I am new to DB2 and not sure how I can cast the field in db2 so my both mapping are of date datatype.I tried with To_date but i guess the version that i have doesn't support.Looks like the DB2 version I have is 7.

Any help is appreciated !!!

All responses (4)

Answers (0)

GPrasanna 140 on at

Like (0)

Report

RE: Date datatype issue in SSIS

The issue is in the Lookup query. The OELDB source query returns date field and the lookup query field returns string.So I am unable to do lookup mapping .
David Jennaway 14,063 on at

Like (0)

Report

RE: Date datatype issue in SSIS

You can use a Data Conversion step in SSIS to convert data-types in SSIS, if that helps
GPrasanna 140 on at

Like (0)

Report

RE: Date datatype issue in SSIS

Thank you for the response. Will do that.
LuHao 40,876 on at

Like (0)

Report

RE: Date datatype issue in SSIS

Hi partner,

I would recommend you also post this theme at SQL Server community.

techcommunity.microsoft.com/.../SQL-Server