Destination table has a column name - Partition that is a key word in the DB2 database. But database would execute the query fine if there is "" around the column name - "Partition". When an OLE DB Destination component is used, it throws an error saying column name is a reserved word and that it cannot be used. When put "" around the column name, it fails in the pre-execute phase thinking that "Partition" is the column name instead of Partition. Any ideas to fix this problem would be greatly appreciated?
What OLE driver are you using for DB2?|||Phil,
I am using 'IBM OLE DB Provider for DB2'. Any suggestions on what I should do to fix the problem?
|||First, do square brakets work? [Partition]Second, is your data flow column called Partition, or something else and you're mapping it to a column named Partition? What I'm getting at here, is you can alias the column in the data flow to be something other than "Partition." That might help.
Also, you could try using the Microsoft OLE for DB2 driver.
No comments:
Post a Comment