Member Avatar for 21KristianN

Dear members

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?

\Kristian

  • 2 Contributors
  • 2 Replies
  • 95 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by 21KristianN

Recommended Answers

All 2 Replies

Member Avatar for sknake

What version of SQL Server are you running? DTS was available in MSSQL 2000 but replaced with SQL Server Integration Services in MSSQL 2005 and later. You may consider reading up on SSIS.

If you are using MSSQL 2000 then you can create a DTS package for the import and schedule it to run nightly. You can configure the package to drop & recreate the table, truncate it, or append. This all depends if you're going to be providing incremental data files for the import or if they are complete.

Member Avatar for 21KristianN

Thank you for fast reply. That was what i needed..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.