How to insert into Teradata table from asp.net detatable?

Teradata Applications
Highlighted
New Member

How to insert into Teradata table from asp.net detatable?

I have a datatable (i.e. dt_employee) in c#.net, which has around 1million records. How do i insert this dt_employee data into TeraData table EmployeeTable.

1 REPLY
Senior Apprentice

Re: How to insert into Teradata table from asp.net detatable?

Hi,

 

What have you tried? (always useful to know that so that we don't give you an answer you've already tried).

 

An obvious approach is to use the dot net data provider, but with @1million rows that will be slow. For speed you'd want to use an array insert (I'm fairly certain the DP supports this) and ideally use multiple connections. Docs for the DP are here (although this might be a slightly older version).

 

An alternative would be to write the data to a file on your pc and then use TPT Load/Fastload for the loading.

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com