[cisco-voip] Automatically importing CDR files in SQL

[Teixeira, Mike]

I setup a SSIS package to be run as a SQL 2005 job. There are three steps to a job:

Move CDR flat files to a different directory than the FTP directory
Import multiple flat files into CDR database
Empty the contents of the directory.

Mike

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Curtis, Adam
Sent: Friday, September 04, 2009 7:46 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Automatically importing CDR files in SQL

We have our CDR records off loaded to a server nightly and we're now trying to come up with the best way to automatically import the flat files into the SQL database. I was curious as to what tools anyone out there might be using and/or what type of system you have come up with. Any thoughts or ideas are appreciated!
Thank you,

Adam Curtis
Pizzagalli Construction Company
IT Support Technician
(802) 651-1319

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090904/5faaa471/attachment.html>