I have a given data file to be loaded into a SQL table. I want a
sample vbscript that shows how I can do processing record by record.
What I am looking for is a mechanism that enables me to process the
incoming record by record for various checks and if a check is not
satisfied to reject or skip the record else to process and load the
record into SQL.

I would be thankful if you could show me a simple script skeleton that
accomplishes this.


Thanks
Karen

"Karen Middleton" <karenmiddleol (AT) yahoo (DOT) com> wrote

Define an ActiveX script in the trasformation tab. This script is executed
record by record while importing rows. Then add code like this, replacing
<condition> with your condition; in this way you'll add only the record
that match your condition:

Function Main()
DTSDestination("EmployeeID") = DTSSource("EmployeeID")
DTSDestination("LastName") = DTSSource("LastName")
DTSDestination("FirstName") = DTSSource("FirstName")
...
if <Condition> then
Main = DTSTransformStat_OK
else
Main = DTSTransformStat_SkipRow
end if

End Function

Francesco Anti

Karen Middleton wrote:
Mr. Anti has already given you a great method. An alternative to this would be to load the whole file and then use SQL
commands to delete the rows that should not be there. There are pros and cons to each approach depending on the situation.
--
To Email Me, ROT13 My Shown Email Address