December 9, 2011 at 9:12 am
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
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
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
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
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