August 29, 2016 at 3:27 pm
I have oledb source to excel destination. I have data conversion transformation to cahnge the datattype of the column. The excel source takes the column from both oledb source and data conversion task and throws error " coulmn names are used mor etahn once" even though i have same column name in data conversion transformation too.
please help to resolve.
August 29, 2016 at 3:43 pm
Does the spreadsheet have column names that are used more than once?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 29, 2016 at 4:02 pm
This is resolved by unchecking the column in excel destinations ---> columns section
August 29, 2016 at 4:06 pm
I am still having issue with the order of column s it appears.
example : column 1 , column 2 ...column 5
The file shows : column 5 , column 3 , column 4 , column1 , column 2
Is there nay way i change the column order on destiantion ?
August 29, 2016 at 8:19 pm
Columns are read or written in the order they are defined in the connection manager. If you're having a problem with the order, check the connection manager.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply