Hi there. It is a direct load.ETLJOB wrote:Is it a direct load or do you have some other logic in between?
Search found 2 matches
- Tue Aug 31, 2010 11:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading from dataset to new SQL table scrambles table layout
- Replies: 5
- Views: 3591
- Tue Aug 31, 2010 10:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading from dataset to new SQL table scrambles table layout
- Replies: 5
- Views: 3591
Loading from dataset to new SQL table scrambles table layout
Hi.
I'm trying to create a new SQL 2005 table by loading from a dataset into SQL. The loading stage is SQL Server Enterprise.
My problem is that it creates the table, but the column ordering is not the same as the dataset. Any assistence would be GREATLY appreciated
Thx.
I'm trying to create a new SQL 2005 table by loading from a dataset into SQL. The loading stage is SQL Server Enterprise.
My problem is that it creates the table, but the column ordering is not the same as the dataset. Any assistence would be GREATLY appreciated
Thx.