DSXchange

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.

Is it a direct load or do you have some other logic in between?

ETLJOB wrote:Is it a direct load or do you have some other logic in between?

Hi there. It is a direct load.

Uncheck the RCP option if it is enabled and give a try.

As an alternate, the table can be created in target first and you can use datastage to load.

It's a known "issue", no clue why it does what it does, but it does.

I had a similar experience with the ODBC stage. I created the table and then ran the job, which I am sure you are also doing now. I really wonder what's the problem!