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!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
