Post reply

SSIS - Script COmponent

  • December 9, 2011 at 9:12 am

    #144674

    Apologies - This has been posted in the BI Section as well ..

    Hi All,

    I am looking to use the Script Component to import a flat file and add a blank column to it .. where I will enter data from the other columns from the same file using code.

    Can you suggest the basic steps to me ..

    Many thanks,

  • December 9, 2011 at 9:41 am

    #1419500

    I'm not 100% convinced you need to use a script task to do this.

    Why don't you explain your needs and we'll help you with a solution as opposed to trying to make a particular solution work.

    CEWII

  • December 9, 2011 at 9:49 am

    #1419510

    Hi Eliott,

    Many thanks for your reply

    I have a series of csv files where I need to

    1. search for a string say 'ZZZ' in column B.

    2. Copy a string from cell C1 in a new column till the next occrence of 'ZZZ'

    3. Then repeat for another sring inm column B and re-run

    Basically like repetitive data automation task in Excel ... but I have to do this in SSIS for every file put them in the required format and then perform other data transformations.

    If I have not been clear then I could elaborate.

    Thanks

  • December 9, 2011 at 11:39 am

    #1419560

    At first blush I wold probably use a normal flat file source but use a script transform. I try not do use Script sources as much as I can but have in cases where no other source would really do... You define the new column in the script and I'm fairly sure the pipeline will give you the records in the order they appear in the file, if not then a script source may be required..

    CEWII

  • December 10, 2011 at 12:23 am

    #1419682

    Thank you .. I will give that a try

Viewing 5 posts - 1 through 4 (of 4 total)

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