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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply