Help Please..
Posted: October 22nd, 2012, 11:21 pm
Hey Everyone,
I'm really new at CSpro 4.0. im task to export survey data and migrate that data to our Resident Information System. i got it by exporting the data via export tool as "tad-Delimited", 'Multiple FIles" and "As Separate Records."
were using MS SQL 2k8 as aback end of our Resident Information System. what i did was just import the tab delimted files (.txt) to MS SQL. then i did our the migration by defining a stored procedure. while checking my migrated result. i found out that there were mulitiple records of the same person of the same information. so i investigate my script. and it was OK. then i investigated the my imported tables (imported tab-delimited files) and i found out that there were records in the Household Information that were using the same control number(HCN). and i need that HCN to be unique because that HCN is what i used to connect with other tables that i imported in SQL.
so my question is, is there a way to correct this control number (HCN) before i can export it as tab-Delimited file.
I really need help.
I'm really new at CSpro 4.0. im task to export survey data and migrate that data to our Resident Information System. i got it by exporting the data via export tool as "tad-Delimited", 'Multiple FIles" and "As Separate Records."
were using MS SQL 2k8 as aback end of our Resident Information System. what i did was just import the tab delimted files (.txt) to MS SQL. then i did our the migration by defining a stored procedure. while checking my migrated result. i found out that there were mulitiple records of the same person of the same information. so i investigate my script. and it was OK. then i investigated the my imported tables (imported tab-delimited files) and i found out that there were records in the Household Information that were using the same control number(HCN). and i need that HCN to be unique because that HCN is what i used to connect with other tables that i imported in SQL.
so my question is, is there a way to correct this control number (HCN) before i can export it as tab-Delimited file.
I really need help.