Delete data from the table before loading

[Ankor]

What transformation task should be used to delete data from the table before loading. I tried OLEDB Command, but it requires input columns. What input should I provide for the delete command? I attempted to put this command between source and destination (looks really weird), but it works in one small package. The big one hangs, which is not surprising, but I don't know how else the delete command can be called. Thank you.

 

[manmaria]

Can't you do a sql task and write the sql for delete/truncate?

 

[Ankor]

There is no SQL task in Data Flow Transformations, or I guess they all are SQL tasks, but I don't see anything similar to "Execute SQL Task" that we had in SQL 2000 DTS.

 

[manmaria]

Why do you want to start with Dataflow first? If there is no reason then start in Control Flow task, add a 'execute sql task' and write your sql then do whatever you want. If there is a reason you want to start with Dataflow task then create the OLEDB source task first and select your source table THEN create the OLEDB command task and write the delete statement in sqlcommand.

HTH

 

[Ankor]

I was trying to put all data flow tasks withing one control flow task. I have some more transformations in the same package, and it looks like I have to separate them. I figured how to do it using source and OLEDB command task, but I think I can also use your first solution. Thank you for your help.