I'm using a datapump task to transfer records from a CSV file to a table,I
am doing validation while tranforming and when it's done ,I use an stored
procedure to enforce my business rules.somebody told me that Data Driven
task will do the same thing and it's better than using stored procedure.My
stored peocedure to check the business rules is fairly complex.I just
wondered if DataDriven gives me a better way of doing so.

Thanks

A DDQ will operate on every row of data Row * Row (As will an Active
Script transform with Lookups). Personally until the next version of
DTS comes out I would

Stage the text file and perform TSQL upon it to get it into your proper
structure.

Allan

"RayAll" <RayAll (AT) microsft (DOT) com> wrote

I didn't finally get weather you would use it or not?
Sorry about that.Can u giive me more explanation?

Thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Personally I would probably not use it although I can see how it is noce
and convenient. I would consider for small datasets only.

Allan

"Ray5531" <Ray5531 (AT) microsoft (DOT) com> wrote

So you think row per row processing is the only disadvantage of using DDQ?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Yeah pretty much.



"RayAll" <RayAll (AT) microsft (DOT) com> wrote

Thanks Allan,
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Whilst I have not been overly kind to this task it can be your friend so
test your intended solutions and see which fits to your constraints the
best

Allan

"RayAll" <RayAll (AT) microsft (DOT) com> wrote