odbcwrite stage
Posted: Wed Feb 11, 2009 11:03 am
I am trying to use the above operator to read a simple file of 15 fields. When the source data is delimited, and so we do not have a record length it fails with this error
Fatal Error: Not bounded length.
When I set the data to fixed length it works OK. But the Oracle writer does not require this. It just gives a warning that the data may be truncated.
How can I work around this?
A second, weirder problem. We have two SQL Server instances. One in Poland and one in the UK. When I load the exact same data, using the exact same script to the UK it works OK. When I load it to the database in Poland, the first record from each partition is inserted correctly, but all other records have the first character of every field replaced with a NULL character.
The only difference in the SQL Server installs is one has the default collation set to Latin1 the other set to Polish.
Can anyone help?
Thanks
Jon
Fatal Error: Not bounded length.
When I set the data to fixed length it works OK. But the Oracle writer does not require this. It just gives a warning that the data may be truncated.
How can I work around this?
A second, weirder problem. We have two SQL Server instances. One in Poland and one in the UK. When I load the exact same data, using the exact same script to the UK it works OK. When I load it to the database in Poland, the first record from each partition is inserted correctly, but all other records have the first character of every field replaced with a NULL character.
The only difference in the SQL Server installs is one has the default collation set to Latin1 the other set to Polish.
Can anyone help?
Thanks
Jon