You could use any kind of programming to do this as well... Like java or cold fusion
even. Just read in the file, parse it out, check for errors and do inserts.
Travis
---- Original Message ----
From: [EMAIL PROTECTED]
Sent: 2001-12-13 12:21:18.0
To: SQL <[EMAIL PROTECTED]>
Subject: Re: Can I use DTS for this?
With a little elbow grease, DTS would be perfect for this. You can use any
ActiveX script language (VBScript, JScript, and PerlScript are the three I
remember) to validate the data and choose whether to push the record to the
database, skip the record, or error out the entire DTS process. You can
process each record in one big block, or one field at a time, or any
combination of these.
Like most really flexible, powerful systems, it is complex and
intimidating. However, it is an excellent way to accomplish your goal.
|-------------------+-----------------------------------------------------|
|Eric A. Laney |Opera is when a guy gets stabbed in the back, and |
|Systems Engineer |instead of bleeding, he sings. |
|LAN Optimization | |
|Team | |
|Verizon Data | |
|Services | |
|Voice: 813.978.4404| |
|Pager: 888.985.8519| |
| | |
|-------------------+-----------------------------------------------------|
"stas"
<stas@newdel. To: SQL <[EMAIL PROTECTED]>
net> cc:
Subject: Can I use DTS for this?
2001-12-13
14:03
Please
respond to
sql
Here is the scenario:
A text file is made available to us on a weekly basis for FTP download.
1. Grab the file.
2. Drop existing records from a table.
3. Re-populate the table with new data
4. Send success or failure message by e-mail
It looks to me like a DTS package should be able to take care of this,
however I've never used it. My main concern is that the text file will
contain about 10,000 records and not all data will be clean. We need to
skip
over bad records and continue to the end of the file.
Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
