I have a challange. I want to update my CRM database (MSSQL) with turnover numbers from our ERP database. I can retreive the data in different file types from my ERP database so they can be importet as a flat file. But does anybody have a good idea to create a batch update of my turnover records in my CRM database? I have read about the DTS tool for MS SQL but can't fugure out if this tool can help me. The import/update should run automatically every night (perhaps by scheduled tasks)
Any good ideas for me - anbody had the same issue?