May 23, 2012 at 10:29 am
Hi,
I have got a problem with my Excel import. I get a file without column headers. I retrieve the content by a select statement Like :
Select F1, F2, F3......
If I copy the content of the Excel file into another workbook by pasting it into A1 and then try to use the new file as source SSIS mixes up the columns.
F1 is then Column B instead of Column A.
I had the same Problem with another sheet. First Column A was empty data starts at Column B.
Without copy paste and starting with column B I use the following Select Statement:
Select F2, F3, F4......
Worked OK on DEV.
Then I moved the SSIS package from DEV to UAT, but there the content of F2 was now Column C instead of B.
It is like Column A is ignored and F1 starts in Column B.
I have got no clue how to handle this. For UAT I had to change my query to Select F1, F2, F3...... to get it working.
Anyone an idea how to handle this or what might be the reason?
Regards
Chris
May 23, 2012 at 10:43 am
HUH? We can't see what you see and your explanation left me scratching my head trying to figure out what you are even saying.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply