Hi Raghav thanks for the information, Option 2 does look the best solution but accountId is coming as string.so can we use marketId(integer) of lookup table along with accountId (string).Note: market code would be 2 char max. (IN, US etc.) but accountId can be of 10 chars, so anyhow we have to use a string for composite so which would be better? or is there any other solution to have this solution implemented with integer composite key? Maybe we can use autopk(recipientId) and marketId somehow?

Hi Raghav thanks for your reply,1. Let the system have an autopk column and define unique index on the combination of accountid and market code.- This solution looks easy and good for implementation but won't a combination of accountId(string) and marketCode(string) to be used as a composite key would pose issues? or it would work as fine as integer keys? we need to link other tables to this table also through PK-FK relation for which should we use combination of both indexes to identify every o...

Hi Vipul,Thanks for the code. var file = new File( fName );Can this code be modified to use a file downloaded from the file collector activity which is in temp db.Could you please help me with that?