July 16, 2010 at 9:52 am
Hi
I m designing a package.source and destination are OLEDB.I need to map name column from source to shortname and legalname columns in destination.
My question here is,
actually my destination columns shortname and legal name has same information, for example one case shortname is Xtra Airways legalname Xtra Airways. for few shortname is The Gwinnett County Board,legalname isThe Gwinnett County Board of Education.but i have only one column called name in my source and i need to map name to both the columns in destination.where ever my source has shortname formate it should go to shortname otherwise it should go to leagalname.
plz suggest me the steps to do this.
Thanks
Ragha
July 19, 2010 at 7:37 pm
Not sure I'm following completely.
You have a single name column in your source table, and you have a 'shortname' column as well as a 'legalname' column in your destination?
Are you wanting to determine whether the name goes into 'shortname' or 'legalname' based on some criteria?
I think you can accomplish what you're after with a Derived Column transform, but I'll need a little more clarification on your intent first.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply