Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2013-04-05 : 13:22:03
|
| Here's an odd one..I have a simple data flow task that reads a SQL table as its source, converts some columns, and writes to a DB2 destination table.When I run the package, the dataflow task fails at when writing to DB2. Odd thing, is the records get written to the DB2 table.I don't see anything wrong with the retreival, and can write to a test excel file with no issues....Any ideas with this one?Thanks! |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2013-04-08 : 10:50:49
|
| Figured this one out... Primary key violation on the DB2 side... |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-08 : 11:26:08
|
Ahaa, yeah, that'd do it  |
|
|
|
|
|
|
Werid Behavior when writing From SQL Server to DB2