Re: Insert Bulk data (millions) into Teradata using VS20013, c#

You have few choices to improve the performance:

1- Do not hard code values into the Command-Text; Instead pass the parameters using TdCommand.Parameters collection. There are lots of example on MSDN and in the .NET Data Provider documentation / Samples. The samples are in the "Program Files (x86)\Teradata\NET Data Provider for Teradata\15.01\samples" directory.

2- Use TdDataAdapter to pass updates in Batches. MSDN has topics on Batch-Update and the .NET Data Provider documentation also has sections/pages on this topic.