Post reply

extract from excel filename

  • July 21, 2014 at 11:06 am

    #150171

    I have excelfilename starts like abc - usa sales- 1-1-2014. have to extract usa from the filename and insert as a column in excel with columnname 'country'.

  • July 21, 2014 at 11:15 am

    #1731112

    Use a script task in your control flow to get that information from the file name and store it in a variable. You can then use that variable in the data flow to store the value in the spreadsheet.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    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]

  • July 21, 2014 at 11:18 am

    #1731115

    Sorry. I think i have posted in the wrong place..need to do using excel vba

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply