September 22, 2014 at 3:20 pm
Hi, I have a excel sheet exports to sql table. excel name is sporty1284.xls(dynamic excel file)
where "sport"(4 letters from excel filename) should be written to the book column name in sql table.
I have tried with derived column but it doesn't work as it asks for mapping from the excel. my excel doesn't have sport as column name to map.
The 'sport' column is already available in sql table. i know derived column transformation can add new column but i cannot delete and redo every-time.
September 23, 2014 at 5:40 am
Are you using a Foreach loop to process the file?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 23, 2014 at 7:02 am
Hi Phil,
yes i am using for each loop
September 23, 2014 at 7:21 am
susmitha117 (9/23/2014)
Hi Phil,yes i am using for each loop
Are you assigning the file name to a variable? If not, create yourself a variable and ensure that the file name gets assigned to it.
See here [/url]for a description of that (among other things).
Now that you have your file name in a variable, I am assuming that you are happy adding a derived column to your dataflow which extracts the bit you need.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply