April 20, 2012 at 12:04 am
I have a transform task that gets data from an excel file and splits it into two separate text files.
I only need some of the columns provided but in the transform or data pump, on the transformations tab, right click on the transformations and select properties. Here is where one is supposed to be able to set the column order. I set my column order and click on test. Everything looks correct. But when I run the task the order is not correct.
Anyone have any idea on how I can solve this problem.
As usual this has turned into a critical situation for me.
Thanks
Again
April 22, 2012 at 3:31 pm
For completeness, I got this to work
I changed the requirements so to speak.
Instead of trying to export from excel into separate text files I exported excel into a table in sql, then wrote some t-sql statements to extract the data in the order I needed and put that data into the required text files.
Since the final result was to have two separate text files with the columns in a specific order to import into an SAP system, I feel I met the requirements.
Gary
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply