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 |
|
diggott
Starting Member
4 Posts |
 Posted - 2004-10-12 : 08:31:02
|
| Hi,I'm having trouble using DTS to put data stored on SQL Server into DB2 via an ODBC link. The data gets in there and things like timestamps are converting OK. I just seem to have a problem with null values. They come don't come over in the same format as they are in SQL Server.Anyone any suggestions ? |
|
|
diggott
Starting Member
4 Posts |
Posted - 2004-10-13 : 08:58:08
|
| Actually it's alright it turns out the nulls are OK but the blank values in not null fields are put in as tabs by the application so we have a bit of trouble with the translation. Seems to work OK though. Just realising how ridiculously slow DTS is now though. Commit after every row.... !?DB2 Migration Toolkit here we come |
 |
|
|
|
|
|
NULL Conversion problem