I have created a package in DTS which copies the contents of a table in a DB
to a text file based on some standard validations which I have specified in
the transform task properties using Active X script( with VB Script as the
language).

The connections I have used is UDL(universal data link) which takes the
connection properties from the UDL file at a specified location. When I try
to execute it then it fails in spite of the fact that the VB script was
successfully parsed.

But when I simply copy the data without doing any validations then it does
with success ( that is copy all the contents of the table to a flat file)

Any help is highly appreciated

Thanks