Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Suggestions from the Pros

I have a CRM database system and need to feed a comma delimited file on a regualar basis. This feed will update terminated agents, new agents and also keep our CRM addresses current. What would be the best way to approch this task? What should I use to load the data? Before, I was using a combination of programs and scripts but I need to revamp everything. I want it to be simple but meet our business objective but very powerfull and flexable on the backend. I'm using SQL2k.

Thanks,

Corey
[521 byte] By [charbaugh] at [2007-11-11 7:19:12]
# 1 Re: Suggestions from the Pros
I would create a DTS package: http://www.databasejournal.com/features/mssql/article.php/3325731
Phil Weber at 2007-11-11 23:47:50 >