SqlBulkCopy Tutorial - Knowledge Base (KB)

Excel SqlBulkCopy works differently on local pc, and on application server?

My application truncates a database table and fills it with the rows from an excel....Using an excel file (2000 rows), below upload code inserts all the rows to database completely in my local pc (my development environment) and it did in the server too, ...

External table is not in the expected format c#

I have seen more answers while googling it, but couldn't solved my problem. This is the code I have written to insert excel sheet into sql server table.... string strConnection = ConfigurationManager.ConnectionStrings[0].ToString(); string ...

SSIS - OleDB connection not updating data, inserted thru SQLBulkCopy with SQL Connection

I have created Ole DB connection to execute different SQL task across SSIS package. Its working fine too....In one of task where i need to do insert data into table, used SQLBulkCopy as i have dynamic tables and columns based on getting files from differe...