Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-20 : 08:37:23
|
| Matthew writes "How can I check data so that I can make sure that an email address is a valid string, Country codes is 2 Char, first name 30 Char, etc, and place the information into a temp file and the reson why it was rejected so that I my email it to the person.This is for my clients to upload a comma delimited file and select the columns by a drop down box and the information is placed to the database in to the correct column and before it does that it check the data to make sure that the data goes by the rules. If it does not it is rejected but still checks the other rows. It emails out a report telling how many rows was accepted and how many rejected and the reason why.Right now it is designed in Jscipt on IIS 5.0.I want it to schedule the process so that the person do not have to waite until the data is completed.Matthew Mills" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-20 : 09:05:11
|
| You can take your JScript code and use it in a Data Transformation Services (DTS) package as either an ActiveX transformation (used row-by-row) or as an ActiveX task step (used for the entire file). Take a look in Books Online under "DTS" for more information (a lot more! look for "ActiveX data transformations" too) Your code will probably work with very little modification. |
 |
|
|
|
|
|
Datacheck