Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Results Reversed

Status
Not open for further replies.
Earthworks

Earthworks

IS-IT--Management
Sep 30, 2003
16
GB
DTS Package source is a SQL query. When using the preview button the result columns are in the same order as in the SQL query.
The destination tab shows the result columns in the order I require. The transformation tab shows the columns in the order I require. However when I use the test button on the transformation tab the the result preview has the columns reversed i.e first columns is now last and last column is now first. My resulting CSV file also has the columns reversed.

Any one who can show me the error of my ways ?
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Group results into one row 3
2
Replies
37
Views
2K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Returns wrong results
Replies
1
Views
309
Cpreston
Cpreston
WomanPro
  • Locked
  • Question
How to display the results of my query delimited with pipes?
Replies
9
Views
480
WomanPro
WomanPro
bmacbmac
  • Locked
  • Question
SQL 'For json' query for over 100,000 records - truncating results
Replies
2
Views
764
bmacbmac
bmacbmac
jimoo
  • Locked
  • Question
Unexpected Join Results
Replies
3
Views
330
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top