SSDT ODBC issue for DB2 in WINDOWS 10

0.00/5 (No votes)

See more:

I have one SSIS package where I have used ODBC connection to run query in DB2.

When we execute the package from SSDT for Visual studio 2017 in WINDOWS 10 it is throwing error for syntactical issue. Even for simple query.

When we checked the log in DB2 side it has been found that the "SET FMTONLY ON" and "SET FMTONLY OFF" statement is getting added automatically with my query in SQL command text. DB2 cannot recognize the FMTONLY statement and throwing error.

I have tested same issue from SSDT 2015 also in WINDOWS 10. But from WINDOWS 07 , everything working fine. Can anyone please help me on this.

What I have tried:

"SET FMTONLY ON" and "SET FMTONLY OFF" statement is the main culprit. I have changed many properties from SSDT but no hope.

Posted 4-Jul-18 20:35pm

Soumyajit Saha

Updated 5-Jul-18 2:39am

Add a Solution

Comments

#realJSOP 5-Jul-18 7:43am

what is your query?

Soumyajit Saha 5-Jul-18 8:24am

A simple select query in DB2 table. But SET FMTONLY statement is getting added automatically. When DBA checked it from database log in DB2 , they have found that.

#realJSOP 5-Jul-18 9:37am

Did you google this at all?

Soumyajit Saha 6-Jul-18 5:17am

A lot. But no hope.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Rick York	90
Richard MacCutchan	65
Graeme_Grant	60
Richard Deeming	55
Dave Kreskowiak	50

Pete O'Hanlon	1,820
OriginalGriff	1,355
Graeme_Grant	895
Richard Deeming	798
Dave Kreskowiak	684

SSDT ODBC issue for DB2 in WINDOWS 10

Add your solution here

Preview 0

SSDT ODBC issue for DB2 in WINDOWS 10

Add your solution here

Preview 0

Existing Members

...or Join us