hi,
i have a back up text file(csv). it has an action character
(Update/Delete/Insert) at the first of the line. so far, i read the text
file from my c# code and populate to the table. but, i feel it's a bit slow.
can i change this process to dts. but, i'm afraid that there's an action
character which isn't a database field.
if there's some solution for that, please help me.

regards,
ingwanjawa

Hello myo,

You can use the Data Driven Query task to do this but this may be slow also.

i would be tempted to BULK INSERT the file into a staging table and then
call a series of TSQL statements based on what the action should be. This
way you can update all of each type of action in 1 batch.

allan

thanks allan,
i'll try with bulk insert.

myo

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