TechQA.

Question

Copy multiple CSV files to SQL Server tables using PowerShell, each CSV is named same as table name

score 51 · Answer 1 · 2024-03-26T14:20:38.697000

0

Answer

51

Views

Copy multiple CSV files to SQL Server tables using PowerShell, each CSV is named same as table name

51 views Asked by Harsh Shah At 26 March 2024 at 14:20

score 44 · Answer 2 · 2024-03-09T21:13:58.197000

Error when using C# class SqlBulkCopy to write to table with ColumnStore index

44 views Asked by Frantz At 09 March 2024 at 21:13

score 57 · Answer 3 · 2024-03-01T19:09:54.123000

SQL Bulkcopy Error "The given value of type String from the data source cannot be converted to type nvarchar of the specified target column"

57 views Asked by SilverFish At 01 March 2024 at 19:09

score 70 · Answer 4 · 2024-02-16T14:42:12.910000

Building a data migration tool to migrate data from MySQL to SQL Server

70 views Asked by smith At 16 February 2024 at 14:42

score 56 · Answer 5 · 2023-12-20T07:15:09.687000

How can I do SQL column mappings ignoring missing columns?

56 views Asked by Sally At 20 December 2023 at 07:15

score 131 · Answer 6 · 2023-09-22T15:45:08.613000

DataTable and big SqlDecimal

131 views Asked by Alsin At 22 September 2023 at 15:45

score 93 · Answer 7 · 2023-09-18T21:18:27.790000

Error when importing data from Excel to SQL Server with CLR

93 views Asked by Stackoverflowuser At 18 September 2023 at 21:18

score 66 · Answer 8 · 2023-07-26T06:30:41.897000

implement bulk copy in different environment

66 views Asked by proram013 At 26 July 2023 at 06:30

score 463 · Answer 9 · 2023-07-20T08:32:30.927000

504 Gateway Timeout: STRANGE!!! while server accepting the file into DB the response is not making it to the Client

463 views Asked by Nara Omur At 20 July 2023 at 08:32

score 90 · Answer 10 · 2023-06-29T12:21:20.830000

WriteToServerAsync Not working as expected when Upgrade to .net 6

90 views Asked by Roshmi Augustine At 29 June 2023 at 12:21

score 236 · Answer 11 · 2023-06-01T14:24:03.930000

SqlBulkCopy WriteToServer using a DataTable just does nothing

236 views Asked by bomberman2910 At 01 June 2023 at 14:24

score 51 · Answer 12 · 2023-05-27T11:34:02.943000

Get primary keys after inserting data into SQL Server database using SqlBulkCopy

51 views Asked by Sri Ram Kumar At 27 May 2023 at 11:34

score 171 · Answer 13 · 2023-05-10T15:27:56.900000

Why would SqlBulkCopy be extremely slow sometimes?

171 views Asked by Eduardo Wada At 10 May 2023 at 15:27

score 70 · Answer 14 · 2023-05-10T09:05:37.343000

Need to improve speed of processing

70 views Asked by Manjay At 10 May 2023 at 09:05

score 785 · Answer 15 · 2023-04-25T15:19:42.513000

BULK INSERT into Managed Instance from a file in Azure Files?

785 views Asked by mbourgon At 25 April 2023 at 15:19

score 463 · Answer 16 · 2023-03-25T16:08:22.043000

Powershell, SQL Server, SQLBULKCOPY: Syntax to specify codepage or encoding

463 views Asked by Bruce Foxton At 25 March 2023 at 16:08

score 322 · Answer 17 · 2023-03-24T18:16:29.227000

SqlBulkCopy failing when trying to handle more than 1 row

322 views Asked by Simon Painter At 24 March 2023 at 18:16

score 248 · Answer 18 · 2023-03-13T11:24:00.757000

How to improve SqlBulkCopy performance with Azure SQL

248 views Asked by Weanich Sanchol At 13 March 2023 at 11:24

score 682 · Answer 19 · 2023-02-07T13:21:20.880000

Copy contents of the Excel file from a stream asynchronously using SqlBulkCopy

682 views Asked by JohnDiGriz At 07 February 2023 at 13:21

score 354 · Answer 20 · 2023-01-17T15:56:39.053000

Powershell, SQL Server, SQLBULKCOPY: Importing NULL Values in .csv

354 views Asked by Bruce Foxton At 17 January 2023 at 15:56

TechQA.

List Question

Copy multiple CSV files to SQL Server tables using PowerShell, each CSV is named same as table name

Error when using C# class SqlBulkCopy to write to table with ColumnStore index

SQL Bulkcopy Error "The given value of type String from the data source cannot be converted to type nvarchar of the specified target column"

Building a data migration tool to migrate data from MySQL to SQL Server

How can I do SQL column mappings ignoring missing columns?

DataTable and big SqlDecimal

Error when importing data from Excel to SQL Server with CLR

implement bulk copy in different environment

504 Gateway Timeout: STRANGE!!! while server accepting the file into DB the response is not making it to the Client

WriteToServerAsync Not working as expected when Upgrade to .net 6

SqlBulkCopy WriteToServer using a DataTable just does nothing

Get primary keys after inserting data into SQL Server database using SqlBulkCopy

Why would SqlBulkCopy be extremely slow sometimes?

Need to improve speed of processing

BULK INSERT into Managed Instance from a file in Azure Files?

Powershell, SQL Server, SQLBULKCOPY: Syntax to specify codepage or encoding

SqlBulkCopy failing when trying to handle more than 1 row

How to improve SqlBulkCopy performance with Azure SQL

Copy contents of the Excel file from a stream asynchronously using SqlBulkCopy

Powershell, SQL Server, SQLBULKCOPY: Importing NULL Values in .csv

Popular Questions

Trending Questions