Date datatype issue in SSIS

(0) Share

Report

Posted on by GPrasanna

142

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 !!!

I have the same question (0)

All responses (4)

Answers (0)

LuHao 40,892 on at

Like (0)

Report

Hi partner,

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

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

Was this reply helpful? Yes No
GPrasanna 142 on at

Like (0)

Report

Thank you for the response. Will do that.

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

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

Was this reply helpful? Yes No
GPrasanna 142 on at

Like (0)

Report

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 .

Was this reply helpful? Yes No