MS SQL Server DTS - Transform task Source Column order automatically reversed

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Transform task Source Column order automatically reversed

Terence Leung

2006-03-23, 8:35 pm

I came across a very strange behaviour in DTS in SQL Server 2000 (it has SP4
but I don't know if it's relevant). After I added all the columns as source
columns in a transformation task's Options -> Source Columns tab (whether one
by one or all at once), the column order is completely reversed (instead of
COL001, COL002... it lists COL019, COL018...). The problem is I have been
using ordinal to access the columns and it gave me the order that is listed
in that window.

I have at least 3 other packages that are done this way without any problem
but this is the only one that exhibited this behaviour, anyone clue?

Sponsored Links