importing data to sql server

Looking at db writer node and db insert node to import data to sql server. If I import data from an data file seems it seems there should be a delete data prior to importing data checkbox. I guess neither node provides a check box to delete data but I see a checkbox in db writer to delete the table (which then I assume a table will be generated prior to importing data). Am I understanding this right?

Thanks,
Jeff

Yes, table will be deleted and recreated corresponding to data structure.

How does recreating table know primary key?

It does not. Yo need to take care. Better use DB Merge and Delete/ Truncate.

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.